summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/t/old_passwords_func.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sys_vars/t/old_passwords_func.test')
-rw-r--r--mysql-test/suite/sys_vars/t/old_passwords_func.test11
1 files changed, 0 insertions, 11 deletions
diff --git a/mysql-test/suite/sys_vars/t/old_passwords_func.test b/mysql-test/suite/sys_vars/t/old_passwords_func.test
index 2707fc3ab6d..bf1d7dcc874 100644
--- a/mysql-test/suite/sys_vars/t/old_passwords_func.test
+++ b/mysql-test/suite/sys_vars/t/old_passwords_func.test
@@ -33,7 +33,6 @@ SET @global_secure_auth = @@GLOBAL.secure_auth;
--echo '#------------------------FN_DYNVARS_115_01---------------------------#'
---echo ** Connection default **
connection default;
#
@@ -54,25 +53,20 @@ CREATE USER 'userOldPass'@'localhost' IDENTIFIED BY 'pass3';
SET GLOBAL secure_auth = FALSE;
---echo ** Connecting con1 using username 'userNewPass1' **
connect (con1,localhost,userNewPass1,pass1,);
SELECT CURRENT_USER();
--echo userNewPass1@localhost Expected
---echo ** Connecting con2 using username 'userNewPass2' **
connect (con2,localhost,userNewPass2,pass2,);
SELECT CURRENT_USER();
--echo userNewPass2@localhost Expected
---echo ** Connecting con3 using username 'userOldPass' **
connect (con3,localhost,userOldPass,pass3,);
SELECT CURRENT_USER();
--echo userOldPass@localhost Expected
---echo ** Connection default **
connection default;
---echo ** Disconnecting con1, con2, con3 **
disconnect con1;
disconnect con2;
disconnect con3;
@@ -81,17 +75,14 @@ disconnect con3;
SET GLOBAL secure_auth = TRUE;
---echo ** Connecting con1 using username 'userNewPass1' **
connect (con1,localhost,userNewPass1,pass1,);
SELECT CURRENT_USER();
--echo userNewPass1@localhost Expected
---echo ** Connecting con2 using username 'userNewPass2' **
connect (con2,localhost,userNewPass2,pass2,);
SELECT CURRENT_USER();
--echo userNewPass2@localhost Expected
---echo ** Connecting con3 using username 'userOldPass' **
--disable_query_log
--error ER_SERVER_IS_IN_SECURE_AUTH_MODE
connect (con3,localhost,userOldPass,pass3,);
@@ -100,10 +91,8 @@ connect (con3,localhost,userOldPass,pass3,);
SELECT CURRENT_USER();
--echo userNewPass2@localhost Expected
---echo ** Connection default **
connection default;
---echo ** Disconnecting con1, con2 **
disconnect con1;
disconnect con2;