1** Setup ** 2 3SET @old_secure_auth = @@GLOBAL.secure_auth; 4'#--------------------FN_DYNVARS_144_01-------------------------#' 5SELECT @@GLOBAL.secure_auth; 6@@GLOBAL.secure_auth 71 81 / ON Expected 9'#--------------------FN_DYNVARS_144_02-------------------------#' 10SET GLOBAL secure_auth = OFF; 11CREATE USER 'testUser'@'localhost' IDENTIFIED BY 'newpass'; 12connect con_user1,localhost,testUser,newpass,; 13connection default; 14SET PASSWORD FOR 'testUser'@'localhost' = OLD_PASSWORD('newpass'); 15connect con_user2,localhost,testUser,newpass,; 16connection default; 17'#--------------------FN_DYNVARS_144_03-------------------------#' 18SET GLOBAL secure_auth = ON; 19SET PASSWORD FOR 'testUser'@'localhost' = PASSWORD('newpass'); 20connect con_user3,localhost,testUser,newpass,; 21connection default; 22SET PASSWORD FOR 'testUser'@'localhost' = OLD_PASSWORD('newpass'); 23ERROR 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 24Expected error "Server is in secure auth mode" 25connection default; 26SET PASSWORD FOR 'testUser'@'localhost' = PASSWORD('newpass'); 27connect con_user4,localhost,testUser,newpass,; 28connection default; 29SET GLOBAL secure_auth = @old_secure_auth; 30disconnect con_user1; 31disconnect con_user2; 32disconnect con_user3; 33disconnect con_user4; 34REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'testUser'@'localhost'; 35DROP USER 'testUser'@'localhost'; 36