刚装了mysql8.0,用navicat连接登陆,却出现连接错误,2059错误,用命令行登陆却正常
需要做如下操作:
- 修改配置文件my.ini
将
default_authentication_plugin=caching_sha2_password
改为
default_authentication_plugin=mysql_native_password
- 用命令行登陆root用户
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
flush privileges;
再次navicat登陆 ok了;