• Skip to main content

Uly.me

cloud engineer

  • Home
  • About
  • Archives

MySQL SSL Connection

April 27, 2020

The standard way to connect to MySQL is:

mysql -h hostname -u user -p

mysql -h hostname -u user -p

Here’s how to connect to MySQL with SSL encryption.

mysql -h hostname -u user -p \
--ssl-ca=server-ca.pem \
--ssl-cert=client-cert.pem \
--ssl-key=client-key.pem

mysql -h hostname -u user -p \ --ssl-ca=server-ca.pem \ --ssl-cert=client-cert.pem \ --ssl-key=client-key.pem

Generate the SSL keys from the MySQL server. Download it to the client.

Filed Under: Linux Tagged With: connect, mysql, secure, ssl

Search This Website

Subscribe Via Email

  • Home
  • About
  • Archives

Copyright © 2023