1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
# WL#14281 Caching SHA2 rounds
--source include/not_have_privilege_checks_user.inc
--source include/master-slave.inc
--source include/rpl_connection_master.inc
SELECT @@global.caching_sha2_password_digest_rounds;
CREATE USER wl_14281_7000@localhost IDENTIFIED WITH caching_sha2_password BY 'WL_14281_PASSWORD';
SELECT SUBSTRING(authentication_string, 4,3) AS length FROM mysql.user WHERE user='wl_14281_7000';
connect(wl_14281_conn,localhost,wl_14281_7000,WL_14281_PASSWORD,test,$MASTER_MYPORT);
SELECT user FROM information_schema.USER_ATTRIBUTES;
disconnect wl_14281_conn;
--source include/wait_until_disconnected.inc
connection default;
--source include/sync_slave_sql_with_master.inc
--echo [connection slave]
SELECT @@global.caching_sha2_password_digest_rounds;
SELECT SUBSTRING(authentication_string, 4,3) AS length FROM mysql.user WHERE user='wl_14281_7000';
connect(wl_14281_conn,localhost,wl_14281_7000,WL_14281_PASSWORD,test,$SLAVE_MYPORT);
SELECT user FROM information_schema.USER_ATTRIBUTES;
disconnect wl_14281_conn;
--source include/wait_until_disconnected.inc
connection default;
# Cleanup
--source include/rpl_connection_master.inc
DROP USER wl_14281_7000@localhost;
--source include/rpl_end.inc
|
