Scenario Description
A client failed to connect to MySQL on the cloud using SSL but could connect to a self-built environment or other environments using SSL.
Possible Causes
View error logs of MySQL. From the error message, we know that the issue may be related to the TLS version. Run the following commands to check the TLS versions of MySQL and self-built MySQL respectively.
show variables like '%tls_version%';
It was found that MySQL used TLS v1.2 and the self-built MySQL used TLS v1.1. After checking, it was found that the TLS version of the client was the same as that of the self-built MySQL. Therefore, the self-built MySQL was able to connect, but the MySQL on the cloud could not.
Solution
Upgrade the TLS version of the client to TLS v1.2.