In the last article, I just wrote about installing Mysql, I want to use Navicat to connect, and then I get an error. Record the error here and solve it.

When Navicat connects to MySQL Server8.0 version, Client does not support authentication protocol requested by server appears; the solution is as follows:

The command is as follows:

1.use mysql;

2. alter user’root’@’localhost’ identified with mysql_native_password by’********’;

3. flush privileges;

Read More:

• [Solved] MySQL Error: Client does not support authentication protocol requested by server
• [Solved] Navicat Connect MySQL error: Authentication plugin ‘caching_sha2_password‘ cannot be loaded
• Docker: How to Solve MYSQL8 & Navicat remote connection error
• Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
• [Solved] Navicat connection error 1251 compatibility with docker MySQL
• [Solved] There is a problem with mysql8.0 without password in Navicat connection
• [Solved] MySQL 8 Connect Navicat error: error 2059
• How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
• [Solved] Error: ER_HOST_NOT_PRIVILEGED: Host ‘x.x.x.x‘ is not allowed to connect to this MySQL server
• [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
• host ‘‘ is not allowed to connect to this mysql server Connect MYSQL Error
• MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
• MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
• Navicat connecting to SQL Server Error [How to Solve]
• Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
• [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
• How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
• [Solved] MYSQL Error: ERROR! MySQL server PID file could not be found!
• Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
• ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’