mysql8.0用户的密码已经是mysql_native_password依旧提示caching_sha2-password

问题描述：

1、数据库用户的加密方式里已经是mysql_native_password，但远程链接时依旧提示
Authentication to host"11.xx.x.xxx for user’ejdwhwdas’usingmethod caching_sha2-password’failed with message: Readingfrom the stream has failed

问题原因：

1、只执行了alter user ‘root’@’指定IP’ identified with mysql_native_password by ‘1234’;

解决方式

完整的步骤：
1、ALTER USER ‘root’@‘指定IP’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; #修改加密规则
2、ALTER USER ‘root’@‘指定IP’ IDENTIFIED WITH mysql_native_password BY ‘1234’; #更新一下用户的密码
3、FLUSH PRIVILEGES; #刷新权限