场景:
mysql version:
分析:mysql搭建成功之后没有给localhost赋权
解决方法;
1、通过root用户连接mysql
2、执行以下命令:
mysql>alter user 'root'@'localhost' identified with mysql_native_password by `123456`;
mysql>FLUSH PRIVILEGES;
3、重新使用navicat连接成功
时间:2019-05-11 11:35:28
场景:
mysql version:
分析:mysql搭建成功之后没有给localhost赋权
解决方法;
1、通过root用户连接mysql
2、执行以下命令:
mysql>alter user 'root'@'localhost' identified with mysql_native_password by `123456`;
mysql>FLUSH PRIVILEGES;
3、重新使用navicat连接成功
彻底解决navicat连接mysql报错:1251Client does not support authentication protocol requested by server......
2023-10-20
终极解决navicat远程mysql8报错 1251 Client does not support authentication protocol requested by server
2022-06-11