Mysql8无法使用IP连接,添加用户后,提示ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded
mysql8默认的认证方式是:caching_sha2_password
mysql> show variables like '%auth%'
-> ;
+-------------------------------+-----------------------+
| Variable_name | Value |
+-------------------------------+-----------------------+
| default_authentication_plugin | caching_sha2_password |
+-------------------------------+-----------------------+
1 row in set (0.00 sec)
mysql> set global default_authentication_plugin=mysql_native_password
-> ;
ERROR 1238 (HY000): Variable 'default_authentication_plugin' is a read only variable
无法在线更改
可以手动更改用户密码认证方式
1.手动更改用户密码认证
alter user root@'%' identified with mysql_native_password by 'password';
flush privileges;
2.创建用户自动使用mysql_native_password
在配置文件/etc/my.cnf
添加
default_authentication_plugin=mysql_native_password
重启mysql服务