How to connect to MySQL with SSL certificates

Hi, I'm trying to connect to a MySQL database using the JDBC driver. The MySQL database has SSL authentication enabled and requires 3 keys: client-cert.pem, client-key.pem and client-ca.pem. How do I include these 3 files in my connection?

Answer 1

[Piyush Kumar]

Hi,

To connect to a MySQL database with SSL certificates, the method depends on the tool or language you're using:

• Command Line: You can connect using the following options:

mysql --ssl-ca=ca.pem
      --ssl-cert=client-cert.pem
      --ssl-key=client-key.pem

Refer to this link for more information: https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html

• Java: If you're using Java, you can include the SSL certificate files in the connection URL. Check this link.
• MATLAB: If you are using MATLAB, please check this link.

I also found MATLAB documentation mentioning how to specify the database connection URL, but the SSL option with MySQL is not given.