Client does not support authentication protocol requested by server; consider upgrading MySQL client

<Excerpt in index | 首页摘要>

<The rest of contents | 余下全文>

报错信息:

1
Client does not support authentication protocol requested by server; consider upgrading MySQL client

解决方案:

打开mysql的MySQL Command Line Client 输入:

1
2
3
USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;

localhost:本机地址
123456:要设置的密码