Mysql 8.0的版本,装好之后Navicat远程连接就一直报错1251
如示:1251-Client does not support authentication protocol requested by server;
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsICM38FdsYkRGZkRG9lcvx2bjxiNx8VZ6l2cs0TUYFmZOhVYm5EWh9mUzgVdGdlWqljMMBjVtJWd0ckW65UbM5WOHJWa5kHT20ESjBjUIF2X0hXZ0xCMx81dvRWYoNHLrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdssmch1mclRXY39CXldWYtlWPzNXZj9mcw1ycz9WL49zZuBnL0MzN5AjNzATM0EjMwAjMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
打开mysql命令界面如图输入后即可正常连接;(命令后分号切记)
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘mysql的密码’;
mysql的密码是安装mysql时设置的密码
输入FLUSH PRIVILEGES;