Problem Description:

1. Click testconnection to report an error:

2. The direct connection error after saving is as follows:

3. Use Navicat to connect successfully

4. Using MySQL command line connection error

ERROR 1045 (28000): Access denied for user 'xx'@'xxx.xxx.xxx.xxx:52594' (using password: Yes)
yl@LAPTOP-TQLOQ2A3:~$

Problem-solving:

1. It is observed that Navicat does not use SSL, as shown in the figure:

2. MySQL workbench has the option to use SSL, and there is no option not to use SSL, as shown in the figure:

3. According to the query data, my MySQL workbench version is 8.0.27. Remove the relevant options, uninstall and reinstall 8.0.26. You can see the relevant options (no and if available), as shown in the figure:

4. If it is modified to no or if available, an error is reported:   Access denied for user ‘xx’@’xxx.xxx.xxx.xxx:55839’ (using password: Yes)

5. Uninstall version 8.0.26 and reinstall the older version. Here is 6.3.7 (download address). The connection is successful!

Similar Posts:

• Error in connecting to MySQL via Navicat on MAC
• [Solved] MYSQL8 Error: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
• [Solved] MySQL Workbench 8.0 Error: SSL connection error: SSL is required but the server doesn‘t support it
• [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
• [Solved] MYSQL Error: django.db.utils.OperationalError: (1045:Access denied for user ‘root’@’localhost’ (using password: NO)
• [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
• Linux Login MYSQL Error: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
• When Navicat connects to a database on a server, there is an error prompt: 1130 ‘* *’ host is not allowed to connect to this MySQL server
• [Solved] MYSQL Install and Login Error: Access denied for user ‘ODBC’@’localhost’ (using password: NO)