# Modify the encryption rules
(1) ALTER USER ‘root’@’%’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
# Update the user’s password
(2) ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘password’;
# Refresh permissions
（3）FLUSH PRIVILEGES;
reconnect the Navicat will solve the problem.
(1) ALTER USER ‘root’@’%’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
# Update the user’s password
(2) ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘password’;
# Refresh permissions
（3）FLUSH PRIVILEGES;
reconnect the Navicat will solve the problem.Read More:
- Docker: How to Solve MYSQL8 & Navicat remote connection error
- [Solved] There is a problem with mysql8.0 without password in Navicat connection
- [Solved] Navicat Connect MySQL error: Authentication plugin ‘caching_sha2_password‘ cannot be loaded
- [Solved] MySQL 8 Connect Navicat error: error 2059
- Navicat connected to Mysql error: Client does not support authentication protocol requested by server;
- [Solved] docker mysql SQLSTATE[HY000] [2002] Connection refused
- Docker mysql8 modify password
- 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
- [Solved] Sqlyog always reports an error when creating a new connection.
- MySQL (version 8.0) connection error: 1251 [How to Solve]
- C# Connect MYSQL Error: MySql.Data.MySqlClient.MySqlException:“SSL Connection error.”
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- IDEA maven Config MYSQL Connection Error: Could not create connection to database server.
- [Solved] mysql 2003 remote access failed mysql8 configure remote access
- [Solved] MySQL connection error: communications link failure
- C# connection MySQL error: SSL connection error [Solved]
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- [Solved] Centons7 docker:mysql:5.7 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
- Android connection to cloud MySQL error: java.lang.NoClassDefFoundError Failed resolution of LjavasqlSQLType