## I. Verify that password hashes created with default digest-rounds ## can be used with X Plugin & X Client # # 1. Show that accounts original credentials are working, # change accounts credentials using (set password, alter user). # 2. Show that old credentials doesn't work. # 3. Show that new credentials are working. # ## II. Verify that password hashes created with default digest-rounds ## and changed with new digest-rounds can be used with X Plugin & X Client # 1. Change servers digest-rounds # 2. Show that accounts original credentials are working, # change accounts credentials to generate a password-hash using new # digest-rounds (set password, alter user). # 3. Show that old credentials doesn't work. # 4. Show that new credentials are working. # # CREATE USER 'change_pwd_alter'@'%' IDENTIFIED WITH caching_sha2_password BY 'alter1'; CREATE USER 'change_pwd_set'@'%' IDENTIFIED WITH caching_sha2_password BY 'set1'; # # I.1 RUN ALTER USER 'change_pwd_alter'@'%' IDENTIFIED BY 'alter2' 0 rows affected Mysqlx.Ok { msg: "bye!" } ok RUN SET PASSWORD='set2' 0 rows affected Mysqlx.Ok { msg: "bye!" } ok # # I.2 Application terminated with expected error: Access denied for user 'change_pwd_alter'@'localhost' (using password: YES) (code 1045) ok Application terminated with expected error: Access denied for user 'change_pwd_set'@'localhost' (using password: YES) (code 1045) ok # # I.3 RUN SELECT 'ok' as THIS_MUST_BE_EXECUTED THIS_MUST_BE_EXECUTED ok 0 rows affected Mysqlx.Ok { msg: "bye!" } ok RUN SELECT 'ok' as THIS_MUST_BE_EXECUTED THIS_MUST_BE_EXECUTED ok 0 rows affected Mysqlx.Ok { msg: "bye!" } ok DROP USER 'change_pwd_alter'@'%'; DROP USER 'change_pwd_set'@'%'; DROP USER IF EXISTS 'create_pwd'@'%'; Warnings: Note 3162 Authorization ID 'create_pwd'@'%' does not exist. CREATE USER 'change_pwd_alter'@'%' IDENTIFIED WITH caching_sha2_password BY 'alter1'; CREATE USER 'change_pwd_set'@'%' IDENTIFIED WITH caching_sha2_password BY 'set1'; # # II.1 # restart: --caching_sha2_password_digest_rounds=10000 CREATE USER 'create_pwd'@'%' IDENTIFIED WITH caching_sha2_password BY 'create2'; # # II.2 RUN ALTER USER 'change_pwd_alter'@'%' IDENTIFIED BY 'alter2' 0 rows affected Mysqlx.Ok { msg: "bye!" } ok RUN SET PASSWORD='set2' 0 rows affected Mysqlx.Ok { msg: "bye!" } ok # # II.3 Application terminated with expected error: Access denied for user 'change_pwd_alter'@'localhost' (using password: YES) (code 1045) ok Application terminated with expected error: Access denied for user 'change_pwd_set'@'localhost' (using password: YES) (code 1045) ok # # II.4 RUN SELECT 'ok' as THIS_MUST_BE_EXECUTED THIS_MUST_BE_EXECUTED ok 0 rows affected Mysqlx.Ok { msg: "bye!" } ok RUN SELECT 'ok' as THIS_MUST_BE_EXECUTED THIS_MUST_BE_EXECUTED ok 0 rows affected Mysqlx.Ok { msg: "bye!" } ok RUN SELECT 'ok' as THIS_MUST_BE_EXECUTED THIS_MUST_BE_EXECUTED ok 0 rows affected Mysqlx.Ok { msg: "bye!" } ok # restart: DROP USER 'change_pwd_alter'@'%'; DROP USER 'change_pwd_set'@'%'; DROP USER IF EXISTS 'create_pwd'@'%';