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