Help

Welcome!

This community is for professionals and enthusiasts of our products and services.
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.

0

Authentication method 'caching_sha2_password' not supported by any of the available plugins

Avatar
Administrator

遇到这个问题是本机用的mysql是8.0的版本,而之前的版本用的是低版本的5.7或者6.8.


而这个问题的根本其实就是登陆加密的规则不一样,导致用户验证如法通过。




如上图所示,

修改其加密规则以前低版本的(修改mysql配置文件my.cnf或mysqld.cnf):default_authentication_plugin=mysql_native_password;


另外修改完后不要忘记重启mysql服务。

操作步骤:

mysql>ALTER USER 'www'@'%' IDENTIFIED WITH mysql_native_password BY 'Bluetooth123#';

mysql>flush privileges 

重启mysql服务:

1.停止:/etc/init.d/mysql stop

2.启动:/etc/init.d/mysql start

Avatar
Discard