problem causes:
1 In the past, the mysql password authentication plug-in was mysql_native_passwd
2 After mysql8.0 version, the password authentication plug-in uses caching_sha2_password
Method:
Modify the password authentication method and change back to the mysql_native_passwd plug-in
Solution:
1 vim /etc/my.cnf add the following content:
[mysqld]
default_authentication_plugin=mysql_native_password
2 Log in to mysql and execute the following sql:
ALTER USER'root'@'%' IDENTIFIED WITH mysql_native_password BY'password';
flush privileges;
Similar Posts:
- [Solved] MYSQL Error: this authentication plugin is not supported
- [Solved] Deploying Tomcat connection in Linux Navicat reports error 2059 – authentication plugin ‘caching_sha2_Password ‘cannot be loaded: + Xi input 9 g
- MySQL Connect Error: Authentication plugin ‘caching_sha2_password’ cannot be loaded
- [Solved] MYSQL ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
- ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannot be loaded
- [Solved] ER_NOT_SUPPORTED_AUTH_Mode node connection database error
- Error in connecting to MySQL via Navicat on MAC
- [How to Solve] nodejs mysql ER_NOT_SUPPORTED_AUTH_MODE
- [Solved] SQLyog Connect MYSQL Error: 2058 plugin caching_sha2_password could not be loaded
- [Solved] Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by serv