1SET @global_old_passwords = @@GLOBAL.old_passwords;
2SET @session_old_passwords = @@SESSION.old_passwords;
3'#------------------------FN_DYNVARS_115_01---------------------------#'
4** Connection default **
5SET GLOBAL old_passwords = 0;
6Warnings:
7Warning	1681	'old_passwords' is deprecated and will be removed in a future release.
8SET SESSION old_passwords = 0;
9Warnings:
10Warning	1681	'old_passwords' is deprecated and will be removed in a future release.
11CREATE USER 'userNewPass1'@'localhost' IDENTIFIED BY 'pass1';
12CREATE USER 'userNewPass2'@'localhost' IDENTIFIED BY 'pass2';
13** Connecting con1 using username 'userNewPass1' **
14SELECT CURRENT_USER();
15CURRENT_USER()
16userNewPass1@localhost
17userNewPass1@localhost Expected
18** Connecting con2 using username 'userNewPass2' **
19SELECT CURRENT_USER();
20CURRENT_USER()
21userNewPass2@localhost
22userNewPass2@localhost Expected
23** Connection default **
24** Disconnecting con1, con2  **
25DROP USER 'userNewPass1'@'localhost';
26DROP USER 'userNewPass2'@'localhost';
27SET @@GLOBAL.old_passwords = @global_old_passwords;
28Warnings:
29Warning	1681	'old_passwords' is deprecated and will be removed in a future release.
30SET @@SESSION.old_passwords = @session_old_passwords;
31Warnings:
32Warning	1681	'old_passwords' is deprecated and will be removed in a future release.
33