Debian Codegraph @

mysql-test/suite/sys_vars/r/old_passwords_func.result

raw
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 Warnings:
13 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
14 connect con1,localhost,userNewPass1,pass1,;
15 SELECT CURRENT_USER();
16 CURRENT_USER()
17 userNewPass1@localhost
18 userNewPass1@localhost Expected
19 connect con2,localhost,userNewPass2,pass2,;
20 SELECT CURRENT_USER();
21 CURRENT_USER()
22 userNewPass2@localhost
23 userNewPass2@localhost Expected
24 connect(localhost,userOldPass,pass3,test,MASTER_MYPORT,MASTER_MYSOCK);
25 connect con3,localhost,userOldPass,pass3;
26 ERROR HY000: Authentication plugin 'mysql_old_password' couldn't be found in restricted_auth plugin list.
27 connect con3,localhost,userOldPass,pass3,,,,auth=mysql_old_password:mysql_native_password;
28 SELECT CURRENT_USER();
29 CURRENT_USER()
30 userOldPass@localhost
31 userOldPass@localhost Expected
32 connection default;
33 disconnect con1;
34 disconnect con2;
35 disconnect con3;
36 '#------------------------FN_DYNVARS_115_02---------------------------#'
37 SET GLOBAL secure_auth = TRUE;
38 Warnings:
39 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
40 connect con1,localhost,userNewPass1,pass1,;
41 SELECT CURRENT_USER();
42 CURRENT_USER()
43 userNewPass1@localhost
44 userNewPass1@localhost Expected
45 connect con2,localhost,userNewPass2,pass2,;
46 SELECT CURRENT_USER();
47 CURRENT_USER()
48 userNewPass2@localhost
49 userNewPass2@localhost Expected
50 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
51 Expected Error 'Server is running in secure auth mode'
52 SELECT CURRENT_USER();
53 CURRENT_USER()
54 userNewPass2@localhost
55 userNewPass2@localhost Expected
56 connection default;
57 disconnect con1;
58 disconnect con2;
59 DROP USER 'userNewPass1'@'localhost';
60 DROP USER 'userNewPass2'@'localhost';
61 DROP USER 'userOldPass'@'localhost';
62 SET @@GLOBAL.old_passwords = @global_old_passwords;
63 SET @@SESSION.old_passwords = @session_old_passwords;
64 SET @@GLOBAL.secure_auth = @global_secure_auth;
65 Warnings:
66 Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release