| 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; |