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