MySQL - SSL connection

About

Cryptography - Public Key Authentication (Certificate-based, Sender Verification) and SSL - Handshake with MySql

The client is below the mysql cli but it can be another implementation.

For the authentication:

  • You have the private key private of the client <note warning>You need to keep it private.</note>
  • The MySQL Server has the public key of the client

Example

mysql \
    -u root \
    -p password \
    -h hostIPorName \ 
    --ssl-ca=server-ca.pem \
    --ssl-cert=client-cert.pem \
    --ssl-key=client-key.pem

where:


Powered by ComboStrap