Debian Codegraph @

mysql-test/suite/auth_sec/r/server_send_client_plugin.result

raw
1 CREATE USER u1 IDENTIFIED WITH 'mysql_native_password' BY 'foo';
2 CREATE USER u2 IDENTIFIED WITH 'caching_sha2_password' BY 'foo';
3 SHOW VARIABLES LIKE 'default_authentication_plugin';
4 Variable_name Value
5 default_authentication_plugin mysql_native_password
6 SELECT user,plugin FROM mysql.user WHERE user='u1' or user='u2';
7 user plugin
8 u1 mysql_native_password
9 u2 caching_sha2_password
10 SET GLOBAL debug='+d,assert_authentication_roundtrips';
11 SELECT @@debug,current_user();
12 @@debug current_user()
13 d,assert_authentication_roundtrips u1@%
14 ERROR 28000: Access denied for user 'u2'@'localhost' (using password: NO)
15 SET GLOBAL debug='-d,assert_authentication_roundtrips';
16 SELECT @@debug,current_user();
17 @@debug current_user()
18 u2@%
19 DROP USER u1;
20 DROP USER u2;