解决方法:
在 命令提示符界面 进入 mysql安装路径下的bin目录,输入命令:mysql -u root -p
在输入密码,进入mysql操作页面。
依次输入如下命令即可:
use user;alter user 'root'@'localhost' identified with mysql_native_password by 'xxxxxx';flush privileges;
时间:2021-06-04 11:41:49
在 命令提示符界面 进入 mysql安装路径下的bin目录,输入命令:mysql -u root -p
在输入密码,进入mysql操作页面。
依次输入如下命令即可:
use user;alter user 'root'@'localhost' identified with mysql_native_password by 'xxxxxx';flush privileges;
彻底解决navicat连接mysql报错:1251Client does not support authentication protocol requested by server......
2020-09-19
终极解决navicat远程mysql8报错 1251 Client does not support authentication protocol requested by server
2023-01-25