mirror of
https://github.com/MariaDB/server.git
synced 2025-11-03 20:36:16 +01:00
24 lines
1,023 B
Text
24 lines
1,023 B
Text
connection node_2;
|
|
connection node_1;
|
|
SHOW VARIABLES LIKE '%password%';
|
|
Variable_name Value
|
|
default_password_lifetime 0
|
|
disconnect_on_expired_password OFF
|
|
max_password_errors 4294967295
|
|
old_passwords OFF
|
|
report_password
|
|
strict_password_validation ON
|
|
CREATE USER 'user123456'@'localhost';
|
|
GRANT SELECT, INSERT, UPDATE ON test.* TO 'user123456'@'localhost';
|
|
SET PASSWORD FOR 'user123456'@'localhost' = PASSWORD('A$10abcdDCBA123456%7');
|
|
SHOW GRANTS FOR 'user123456'@'localhost';
|
|
Grants for user123456@localhost
|
|
GRANT USAGE ON *.* TO `user123456`@`localhost` IDENTIFIED BY PASSWORD '*5846CF4D641598B360B3562E581586155C59F65A'
|
|
GRANT SELECT, INSERT, UPDATE ON `test`.* TO `user123456`@`localhost`
|
|
connection node_2;
|
|
SHOW GRANTS FOR 'user123456'@'localhost';
|
|
Grants for user123456@localhost
|
|
GRANT USAGE ON *.* TO `user123456`@`localhost` IDENTIFIED BY PASSWORD '*5846CF4D641598B360B3562E581586155C59F65A'
|
|
GRANT SELECT, INSERT, UPDATE ON `test`.* TO `user123456`@`localhost`
|
|
connection node_1;
|
|
DROP USER 'user123456'@'localhost';
|