Navicat连接MySQL-插件密码报错

切换mysql_native_password插件

终端登录mysql

mysql -h localhost -u root -p

查看用户以及密码插件

mysql> SELECT Host, User, plugin from user;
+-----------+------------------+-----------------------+
| Host      | User             | plugin                |
+-----------+------------------+-----------------------+
| %         | root             | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session    | caching_sha2_password |
| localhost | mysql.sys        | caching_sha2_password |
| localhost | root             | caching_sha2_password |
+-----------+------------------+-----------------------+
5 rows in set (0.00 sec)

还原插件

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

点击返回顶部

左上角红星点个赞吧，么么哒～