diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2010-04-05 11:50:31 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2010-04-05 11:50:31 +0200 |
| commit | fedbda3f2fe808aa32b8acdecd282aead778711e (patch) | |
| tree | a568d00d49ea6610584d732b1e961493a58cb6d5 /mysql-test/r/connect.result | |
| parent | 9560ff99c95f680b4c58595bc6b1aeb631128815 (diff) | |
| download | mariadb-git-fedbda3f2fe808aa32b8acdecd282aead778711e.tar.gz | |
fixed a bug in handling mysql_native_password specified explicitly:
CREATE USER mysqltest_up1 IDENTIFIED VIA mysql_native_password
pointers were not always fixed, salt wasn't updated
Diffstat (limited to 'mysql-test/r/connect.result')
| -rw-r--r-- | mysql-test/r/connect.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/connect.result b/mysql-test/r/connect.result index fbe562c283c..7ea5df82758 100644 --- a/mysql-test/r/connect.result +++ b/mysql-test/r/connect.result @@ -225,3 +225,17 @@ Connection on extra port 2 ok # ------------------------------------------------------------------ # -- End of 5.1 tests # ------------------------------------------------------------------ +CREATE USER mysqltest_up1 IDENTIFIED VIA mysql_native_password using '*E8D46CE25265E545D225A8A6F1BAF642FEBEE5CB'; +CREATE USER mysqltest_up2 IDENTIFIED VIA mysql_old_password using '09301740536db389'; +connect(localhost,mysqltest_up1,foo,test,13001,MASTER_SOCKET); +ERROR 28000: Access denied for user 'mysqltest_up1'@'localhost' (using password: YES) +select user(), current_user(); +user() current_user() +mysqltest_up1@localhost mysqltest_up1@% +connect(localhost,mysqltest_up2,newpw,test,13001,MASTER_SOCKET); +ERROR 28000: Access denied for user 'mysqltest_up2'@'localhost' (using password: YES) +select user(), current_user(); +user() current_user() +mysqltest_up2@localhost mysqltest_up2@% +DROP USER mysqltest_up1@'%'; +DROP USER mysqltest_up2@'%'; |