mysql Client does not support authentication protocol requested by server; consider upgrading MySQL

最新推荐文章于 2024-08-04 09:58:47 发布

原创最新推荐文章于 2024-08-04 09:58:47 发布 · 700 阅读

1 ·

CC 4.0 BY-SA版权

Java 专栏收录该内容

92 篇文章

订阅专栏

本文介绍如何登录MySQL数据库并使用root用户进行密码设置，包括通过mysql_native_password插件验证密码的过程。

登入mysql

> mysql -u root -p
#接着输入你的密码

mysql> use mysql;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'r
oot';
Query OK, 0 rows affected (0.40 sec)

mysql> SELECT plugin FROM mysql.user WHERE User = 'root';
+-----------------------+
| plugin                |
+-----------------------+
| mysql_native_password |
+-----------------------+
1 row in set (0.00 sec)