diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/secure_auth_func.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/secure_auth_func.result | 24 |
1 files changed, 13 insertions, 11 deletions
diff --git a/mysql-test/suite/sys_vars/r/secure_auth_func.result b/mysql-test/suite/sys_vars/r/secure_auth_func.result index f7e24e3f043..97d22facd9d 100644 --- a/mysql-test/suite/sys_vars/r/secure_auth_func.result +++ b/mysql-test/suite/sys_vars/r/secure_auth_func.result @@ -9,25 +9,27 @@ SELECT @@GLOBAL.secure_auth; '#--------------------FN_DYNVARS_144_02-------------------------#' SET GLOBAL secure_auth = OFF; CREATE USER 'testUser'@'localhost' IDENTIFIED BY 'newpass'; -** Connecting con_user1 using testUser ** -** Connection default** +connect con_user1,localhost,testUser,newpass,; +connection default; SET PASSWORD FOR 'testUser'@'localhost' = OLD_PASSWORD('newpass'); -** Connecting con_user2 using testUser ** -** Connection default** +connect con_user2,localhost,testUser,newpass,; +connection default; '#--------------------FN_DYNVARS_144_03-------------------------#' SET GLOBAL secure_auth = ON; SET PASSWORD FOR 'testUser'@'localhost' = PASSWORD('newpass'); -** Connecting con_user3 using testUser ** -** Connection default ** +connect con_user3,localhost,testUser,newpass,; +connection default; SET PASSWORD FOR 'testUser'@'localhost' = OLD_PASSWORD('newpass'); -** Connecting con_user4 using testUser ** ERROR HY000: Server is running in --secure-auth mode, but 'testUser'@'localhost' has a password in the old format; please change the password to the new format Expected error "Server is in secure auth mode" -** Connection default** +connection default; SET PASSWORD FOR 'testUser'@'localhost' = PASSWORD('newpass'); -** Connecting con_user4 using testUser ** -** Connection default ** +connect con_user4,localhost,testUser,newpass,; +connection default; SET GLOBAL secure_auth = @old_secure_auth; -Disconnecting Connections con_user1, con_user2, con_user3, con_user4 +disconnect con_user1; +disconnect con_user2; +disconnect con_user3; +disconnect con_user4; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'testUser'@'localhost'; DROP USER 'testUser'@'localhost'; |