diff options
Diffstat (limited to 'mysql-test/main/set_password.test')
| -rw-r--r-- | mysql-test/main/set_password.test | 58 |
1 files changed, 29 insertions, 29 deletions
diff --git a/mysql-test/main/set_password.test b/mysql-test/main/set_password.test index ec652a09274..a4801ba2b6b 100644 --- a/mysql-test/main/set_password.test +++ b/mysql-test/main/set_password.test @@ -36,22 +36,22 @@ create user invalidmysql57auth@localhost identified via 'mysql_native_password' --sorted_result select user, host, password, plugin, authentication_string from mysql.user where user != 'root'; ---connect(con,localhost,natauth,test,) +--connect(con,localhost,natauth,test,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,newpass,test,) +--connect(con,localhost,newpass,test,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,newpassnat,test,) +--connect(con,localhost,newpassnat,test,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldauth,test,) +--connect(con,localhost,oldauth,test,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldpass,test,) +--connect(con,localhost,oldpass,test,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldpassold,test,) +--connect(con,localhost,oldpassold,test,"*NO-ONE*") select current_user(); --disconnect con @@ -59,22 +59,22 @@ select current_user(); flush privileges; ---connect(con,localhost,natauth,test,) +--connect(con,localhost,natauth,test,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,newpass,test,) +--connect(con,localhost,newpass,test,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,newpassnat,test,) +--connect(con,localhost,newpassnat,test,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldauth,test,) +--connect(con,localhost,oldauth,test,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldpass,test,) +--connect(con,localhost,oldpass,test,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldpassold,test,) +--connect(con,localhost,oldpassold,test,"*NO-ONE*") select current_user(); --disconnect con @@ -91,22 +91,22 @@ set password for oldpassold@localhost = PASSWORD('test2'); --sorted_result select user, host, password, plugin, authentication_string from mysql.user where user != 'root'; ---connect(con,localhost,natauth,test2,) +--connect(con,localhost,natauth,test2,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,newpass,test2,) +--connect(con,localhost,newpass,test2,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,newpassnat,test2,) +--connect(con,localhost,newpassnat,test2,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldauth,test2,) +--connect(con,localhost,oldauth,test2,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldpass,test2,) +--connect(con,localhost,oldpass,test2,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldpassold,test2,) +--connect(con,localhost,oldpassold,test2,"*NO-ONE*") select current_user(); --disconnect con @@ -114,36 +114,36 @@ select current_user(); flush privileges; ---connect(con,localhost,natauth,test2,) +--connect(con,localhost,natauth,test2,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,newpass,test2,) +--connect(con,localhost,newpass,test2,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,newpassnat,test2,) +--connect(con,localhost,newpassnat,test2,"*NO-ONE*") select current_user(); --disconnect con --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT --error ER_ACCESS_DENIED_ERROR ---connect(con,localhost,invalidauth,invalid,) +--connect(con,localhost,invalidauth,invalid,"*NO-ONE*") --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT --error ER_ACCESS_DENIED_ERROR ---connect(con,localhost,invalidpass,invalid,) +--connect(con,localhost,invalidpass,invalid,"*NO-ONE*") --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT --error ER_ACCESS_DENIED_ERROR ---connect(con,localhost,invalidpassnat,invalid,) +--connect(con,localhost,invalidpassnat,invalid,"*NO-ONE*") --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT --error ER_ACCESS_DENIED_ERROR ---connect(con,localhost,invalidmysql57auth,invalid,) +--connect(con,localhost,invalidmysql57auth,invalid,"*NO-ONE*") ---connect(con,localhost,oldauth,test2,) +--connect(con,localhost,oldauth,test2,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldpass,test2,) +--connect(con,localhost,oldpass,test2,"*NO-ONE*") select current_user(); --disconnect con ---connect(con,localhost,oldpassold,test2,) +--connect(con,localhost,oldpassold,test2,"*NO-ONE*") select current_user(); --disconnect con @@ -161,7 +161,7 @@ create user foo@localhost identified with mysql_native_password; update mysql.user set authentication_string=password('foo'), plugin='mysql_native_password' where user='foo' and host='localhost'; set password for 'foo'@'localhost' = password('bar'); flush privileges; ---connect foo, localhost, foo, bar +--connect foo, localhost, foo, bar,"*NO-ONE*" select user(), current_user(); show grants; --disconnect foo |