Mysql 8.0 | #08004Client does not support authentication protocol requested by server

2019独角兽企业重金招聘Python工程师标准>>>

完整报错

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

解决方法

Using the old mysql_native_password works:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword';
-- then
FLUSH PRIVILEGES;
This is because caching_sha2_password is introduced in MySQL 8.0.

打个广告: 买云主机上阿里云 <- 优惠,你得优惠我得点零花钱

转载于:https://my.oschina.net/3233123/blog/2986323