Uly.me

cloud engineer

  • Home
  • About
  • Archives
Home/Linux/MySQL SSL Connection

April 27, 2020

MySQL SSL Connection

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

Have content delivered to your mail. Subscribe below.

About Me

I'm Ulysses, Cloud Engineer at Cardinal Health based in Columbus. This blog is about Linux and Cloud technology. When off the grid, I enjoy riding my electric skateboard. I've surfed, snowboarded and played the saxophone in the past. I hope you find this website helpful. It's powered by WordPress and hosted on AWS LightSail.

  • Cloud
  • Linux
  • Git

Copyright © 2012–2021