1
SET @global_old_passwords = @@GLOBAL.old_passwords;
2
SET @session_old_passwords = @@SESSION.old_passwords;
3
SET @global_secure_auth = @@GLOBAL.secure_auth;
4
'#------------------------FN_DYNVARS_115_01---------------------------#'
5
** Connection default **
6
CREATE USER 'userNewPass1'@'localhost' IDENTIFIED BY 'pass1';
7
CREATE USER 'userNewPass2'@'localhost' IDENTIFIED BY 'pass2';
8
SET GLOBAL old_passwords = TRUE;
9
SET SESSION old_passwords = TRUE;
10
CREATE USER 'userOldPass'@'localhost' IDENTIFIED BY 'pass3';
11
SET GLOBAL secure_auth = FALSE;
12
** Connecting con1 using username 'userNewPass1' **
13
SELECT CURRENT_USER();
15
userNewPass1@localhost
16
userNewPass1@localhost Expected
17
** Connecting con2 using username 'userNewPass2' **
18
SELECT CURRENT_USER();
20
userNewPass2@localhost
21
userNewPass2@localhost Expected
22
** Connecting con3 using username 'userOldPass' **
23
SELECT CURRENT_USER();
26
userOldPass@localhost Expected
27
** Connection default **
28
** Disconnecting con1, con2, con3 **
29
'#------------------------FN_DYNVARS_115_02---------------------------#'
30
SET GLOBAL secure_auth = TRUE;
31
** Connecting con1 using username 'userNewPass1' **
32
SELECT CURRENT_USER();
34
userNewPass1@localhost
35
userNewPass1@localhost Expected
36
** Connecting con2 using username 'userNewPass2' **
37
SELECT CURRENT_USER();
39
userNewPass2@localhost
40
userNewPass2@localhost Expected
41
** Connecting con3 using username 'userOldPass' **
42
ERROR HY000: Server is running in --secure-auth mode, but 'userOldPass'@'localhost' has a password in the old format; please change the password to the new format
43
Expected Error 'Server is running in secure auth mode'
44
SELECT CURRENT_USER();
46
userNewPass2@localhost
47
userNewPass2@localhost Expected
48
** Connection default **
49
** Disconnecting con1, con2 **
50
DROP USER 'userNewPass1'@'localhost';
51
DROP USER 'userNewPass2'@'localhost';
52
DROP USER 'userOldPass'@'localhost';
53
SET @@GLOBAL.old_passwords = @global_old_passwords;
54
SET @@SESSION.old_passwords = @session_old_passwords;
55
SET @@GLOBAL.secure_auth = @global_secure_auth;