The server requested authentication method unknown to the client

meShell · 2019-08-25

直接修改密码:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';  

修改my.ini配置文件,改变密码加密方式:

[mysqld]
default_authentication_plugin = mysql_native_password

全栈工程师

196 浏览
0