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