mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 09:55:33 +01:00
76151f3cbc
Don't distinguish between a "password hash" and "authentication string" anymore. Now both are stored in mysql.user.authentication_string, both are handled identically internally. A "password hash" is just how some particular plugins interpret authentication string. Set mysql.user.plugin even if there is no password. The server will use mysql_native_password plugin in these cases, let's make it expicit. Remove LEX_USER::pwhash.
57 lines
1.6 KiB
Text
57 lines
1.6 KiB
Text
--source include/master-slave.inc
|
|
|
|
connection master;
|
|
CREATE USER u1@localhost IDENTIFIED BY 'abcdefghijk';
|
|
connect (user_a, localhost, u1,'abcdefghijk',);
|
|
connection user_a;
|
|
SELECT CURRENT_USER;
|
|
disconnect user_a;
|
|
|
|
connection master;
|
|
CREATE USER IF NOT EXISTS u2@localhost;
|
|
connect (user_a, localhost, u2,,);
|
|
connection user_a;
|
|
SELECT CURRENT_USER;
|
|
disconnect user_a;
|
|
|
|
connection master;
|
|
--sorted_result
|
|
SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
|
|
sync_slave_with_master;
|
|
--sorted_result
|
|
SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
|
|
|
|
connection master;
|
|
CREATE OR REPLACE USER u1@localhost IDENTIFIED BY 'abcdefghijk2';
|
|
connect (user_a, localhost, u1,'abcdefghijk2',);
|
|
connection user_a;
|
|
SELECT CURRENT_USER;
|
|
disconnect user_a;
|
|
connection master;
|
|
--sorted_result
|
|
SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
|
|
sync_slave_with_master;
|
|
--sorted_result
|
|
SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
|
|
|
|
connection master;
|
|
--error ER_CANNOT_USER
|
|
CREATE USER u1@localhost;
|
|
|
|
--error ER_CANNOT_USER
|
|
DROP USER u3@localhost;
|
|
|
|
sync_slave_with_master;
|
|
--sorted_result
|
|
SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
|
|
|
|
connection master;
|
|
DROP USER IF EXISTS u1@localhost;
|
|
DROP USER u2@localhost;
|
|
DROP USER IF EXISTS u3@localhost;
|
|
sync_slave_with_master;
|
|
|
|
--sorted_result
|
|
SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
|
|
|
|
--source include/rpl_end.inc
|