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!