1SET @global_old_passwords = @@GLOBAL.old_passwords; 2SET @session_old_passwords = @@SESSION.old_passwords; 3SET @global_secure_auth = @@GLOBAL.secure_auth; 4'#------------------------FN_DYNVARS_115_01---------------------------#' 5connection default; 6CREATE USER 'userNewPass1'@'localhost' IDENTIFIED BY 'pass1'; 7CREATE USER 'userNewPass2'@'localhost' IDENTIFIED BY 'pass2'; 8SET GLOBAL old_passwords = TRUE; 9SET SESSION old_passwords = TRUE; 10CREATE USER 'userOldPass'@'localhost' IDENTIFIED BY 'pass3'; 11SET GLOBAL secure_auth = FALSE; 12connect con1,localhost,userNewPass1,pass1,; 13SELECT CURRENT_USER(); 14CURRENT_USER() 15userNewPass1@localhost 16userNewPass1@localhost Expected 17connect con2,localhost,userNewPass2,pass2,; 18SELECT CURRENT_USER(); 19CURRENT_USER() 20userNewPass2@localhost 21userNewPass2@localhost Expected 22connect con3,localhost,userOldPass,pass3,; 23SELECT CURRENT_USER(); 24CURRENT_USER() 25userOldPass@localhost 26userOldPass@localhost Expected 27connection default; 28disconnect con1; 29disconnect con2; 30disconnect con3; 31'#------------------------FN_DYNVARS_115_02---------------------------#' 32SET GLOBAL secure_auth = TRUE; 33connect con1,localhost,userNewPass1,pass1,; 34SELECT CURRENT_USER(); 35CURRENT_USER() 36userNewPass1@localhost 37userNewPass1@localhost Expected 38connect con2,localhost,userNewPass2,pass2,; 39SELECT CURRENT_USER(); 40CURRENT_USER() 41userNewPass2@localhost 42userNewPass2@localhost Expected 43ERROR 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 44Expected Error 'Server is running in secure auth mode' 45SELECT CURRENT_USER(); 46CURRENT_USER() 47userNewPass2@localhost 48userNewPass2@localhost Expected 49connection default; 50disconnect con1; 51disconnect con2; 52DROP USER 'userNewPass1'@'localhost'; 53DROP USER 'userNewPass2'@'localhost'; 54DROP USER 'userOldPass'@'localhost'; 55SET @@GLOBAL.old_passwords = @global_old_passwords; 56SET @@SESSION.old_passwords = @session_old_passwords; 57SET @@GLOBAL.secure_auth = @global_secure_auth; 58