Case 1:
In versions before MySQL 8, the encryption rule is mysql_native_Password, and after MySQL 8, the encryption rule is caching_sha2_password。 There are two ways to solve the problem. The first is to upgrade the graphical interface tool version, and the second is to restore the MySQL user login password encryption rules to MySQL_native_password.
the second solution is as follows. After logging into MySQL database with the command line, execute the following command to modify the user password encryption rules and update the user password. Here, modify the user name as“ root@localhost ”The user password rule of is “mysql_native_password”, and the password value is “OK”, as shown in the figure.
//Using mysql database
USE mysql;
//change the password rule and password for the 'root'@'localhost' user
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ok';
//refresh permissions
FLUSH PRIVILEGES;
Situation II
The virtual machine MySQL is connected, and you need to perform the authorization operation
authorize the root user:
grant all on. To ‘root’ @ ‘%’ identified by ‘use password’
flush privileges;
Read More:
- Sqlyog connection MySQL error: 2003 [How to Solve]
- [Solved] Navicat connection error 1251 compatibility with docker MySQL
- [Solved] C# connecting to MySQL database reports an error
- Docker: How to Solve MYSQL8 & Navicat remote connection error
- Database mirroring connection error 4’An error occurred while receiving data: ‘10054(An existing connection was forcibly closed by the remote host.)
- The setobject() method reports an error. The parameter index out of range and MySQL syntax error exception report an error
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- [Solved] SQLSTATE[HY000] [2002] Connection refused to report an error when PHP connects to mysql in the docker container
- MySQL (version 8.0) connection error: 1251 [How to Solve]
- Mysql 8.0.13 Enabling remote access (ERROR 1064 (42000): You have an error in your SQL syntax; check the manual th)
- [Solved] There is a problem with mysql8.0 without password in Navicat connection
- Doris reports an error: error 1064 (HY000) [How to Solve]
- [Solved] there are special symbols in the initial password for installing MySQL in Hadoop, and an error is reported
- IDEA maven Config MYSQL Connection Error: Could not create connection to database server.
- C# connection MySQL error: SSL connection error [Solved]
- [Solved] Navicat Connect MySQL error: Authentication plugin ‘caching_sha2_password‘ cannot be loaded
- After installing mysql5.7 on centos7, an error 1045 (28000) is reported: access denied for user ‘root’ @’localhost ‘(using PAS)
- [Solved] MySQL connection error: communications link failure
- [Solved] docker mysql SQLSTATE[HY000] [2002] Connection refused
- [Solved] MySQL 8 Connect Navicat error: error 2059