爱探索

作者： tearell

  • Navicat连接MySQL-插件密码报错

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