Navicat连接Mysql 8.0.16报错：Client does not support authentication protocol requested by server；

分类: 文章 • 2025-02-08 19:24:34

安装Mysql8.0.16后，用Navicat去连接 localhost，然后报错:Client does not support authentication protocol requested by server；解决方法的命令如下：

use mysql;
alter user 'root'@'localhost' identified with mysql_native_password by '********';
flush privileges;

另：

启动mysql服务：net start mysql
停止mysql服务：net stop mysql

修改密码：ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码'。