client does not support authentication protocol requested by server
今天在新电脑上装环境安的mysql8.0连用navicat连接报错<记录>
打开
MySQL 8.0 Command Line Client
输入密码后
在命令行输入:
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
或 localhost
如忘记密码
mysql -u root -p
set password for 'username'@'host' = password('newpassword')
后执行上面操作