diff options
author | Sergei Golubchik <serg@mariadb.org> | 2019-01-12 15:56:25 +0100 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2019-02-04 15:54:10 +0100 |
commit | c94ec9fc6721f50fadb1d86d1d0bf004b39c69d2 (patch) | |
tree | e94a46af346c4386fc712319be5ba2f1014a11a1 /mysql-test/main/plugin_auth_qa_1.result | |
parent | 3742f6f9aadc363fb83e3775066c33ba420fe97b (diff) | |
download | mariadb-git-c94ec9fc6721f50fadb1d86d1d0bf004b39c69d2.tar.gz |
MDEV-17950 SHOW GRANTS FOR does not work for a user identified with non-existing plugin
Revert the side effect of 7c40996cc866.
Do not convert password hash to its binary representation when a user
entry is loaded. Do it lazily on the first authenticatation attempt.
As a collateral - force all authentication plugins to follow the
protocol and read_packet at least once before accessing info->username
(username is not available before first client handshake packet is read).
Fix PAM and GSSAPI plugins to behave.
Diffstat (limited to 'mysql-test/main/plugin_auth_qa_1.result')
-rw-r--r-- | mysql-test/main/plugin_auth_qa_1.result | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/mysql-test/main/plugin_auth_qa_1.result b/mysql-test/main/plugin_auth_qa_1.result index dd709fee04c..d2d902cb6a6 100644 --- a/mysql-test/main/plugin_auth_qa_1.result +++ b/mysql-test/main/plugin_auth_qa_1.result @@ -149,13 +149,11 @@ new_user test_plugin_server new_dest plug_dest mysql_native_password *939AEE68989794C0F408277411C26055CDF41119 UPDATE mysql.global_priv SET priv=JSON_SET(priv, '$.plugin', 'new_plugin_server') WHERE user='new_user'; FLUSH PRIVILEGES; -Warnings: -Warning 1524 Plugin 'new_plugin_server' is not loaded SELECT user,plugin,authentication_string FROM mysql.user WHERE user != 'root'; User plugin authentication_string new_user new_plugin_server new_dest plug_dest mysql_native_password *939AEE68989794C0F408277411C26055CDF41119 -ERROR 28000: Access denied for user 'new_user'@'localhost' (using password: YES) +ERROR HY000: Plugin 'new_plugin_server' is not loaded UPDATE mysql.global_priv SET priv=JSON_SET(priv, '$.plugin', 'test_plugin_server') WHERE user='new_user'; UPDATE mysql.global_priv SET user='new_dest' WHERE user='plug_dest'; FLUSH PRIVILEGES; |