1
SHOW VARIABLES LIKE 'auth_schema%';
3
auth_schema_table auth.users
4
SELECT MYSQL_PASSWORD('test_pass');
5
MYSQL_PASSWORD('test_pass')
6
34F2496C75CF8F8D8EBE14067C9C8B1AA8E80DEF
10
user VARCHAR(255) NOT NULL,
12
UNIQUE INDEX user_idx (user)
14
INSERT INTO users VALUES ('test_user', '34F2496C75CF8F8D8EBE14067C9C8B1AA8E80DEF');
15
SELECT * FROM users ORDER BY user;
17
test_user 34F2496C75CF8F8D8EBE14067C9C8B1AA8E80DEF
18
SELECT 'connection 1 works';
23
connect(localhost,test_user,foo,test,MASTER_PORT,);
24
ERROR 28000: Access denied for user 'test_user' (using password: YES)
27
user VARCHAR(255) NOT NULL,
29
UNIQUE INDEX user_idx (user)
31
INSERT INTO users2 VALUES ('test_user2', '34F2496C75CF8F8D8EBE14067C9C8B1AA8E80DEF');
32
SELECT * FROM users2 ORDER BY user;
34
test_user2 34F2496C75CF8F8D8EBE14067C9C8B1AA8E80DEF
35
SET GLOBAL auth_schema_table='auth.users2';
36
SHOW VARIABLES LIKE 'auth_schema%';
38
auth_schema_table auth.users2
39
SELECT 'connection 2 works';
44
SET GLOBAL auth_schema_table='auth.users';
45
INSERT INTO auth.users VALUES ('test_user3', MYSQL_PASSWORD('mypass'));
46
SELECT * FROM auth.users WHERE user='test_user3';
48
test_user3 6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4