Before you can teach your client to speak TLS, you will need a certificate issued by a trusted certificate authority (CA). If your organization already runs its own CA and you have a private key and certificate for your MySQL Client client, along with your CA's root certificate, you can skip to the next step.
If your organization does not yet run its own internal CA, you can read more about creating and running a CA using the open source smallstep software here.
To request a certificate from your CA using the
step CLI, run the following command.
Since you're using MySQL Client, which requires RSA keys, we'll pass the
--kty=RSA flag to let
step know to generate RSA keys instead of the default
$ step ca certificate --kty=RSA "myuser" client.crt client.key
Your certificate and private key will be saved in
Request a copy of your CA root certificate, which will be used to make sure each application can trust certificates presented by other applications.
$ step ca root ca.crt
Your certificate will be saved in
Now, we need only to configure our MySQL Client client to make authenticated requests using our certificate and private key. The CA root certificate will be used to verify that the client can trust the certificate presented by the server.
For additional security, step certificates are signed by an intermediate CA by default rather than the root CA. The intermediate certificate is bundled into your
server.crt certificate (configured on the server side).
Unfortunately, MySQL has an outstanding bug that prevents it from being able to read the intermediate certificate out of
server.crt. So, we'll have to instead bundle that intermediate CA certificate together with the root CA certificate we saved previously (
ca.crt) so that our MySQL client can read it and verify the server certificate was signed by your intermediate CA.
$ step certificate bundle $(step path)/certs/intermediate_ca.crt ca.crt ca-bundle.crt
Pass your certificate, private key, and the CA bundle to your MySQL client to authenticate your connection over TLS. The SSL mode
VERIFY_IDENTITY instructs MySQL to verify that the name in our server certificate matches the hostname for the connection, which offers the tightest security.
$ mysql -h myserver.internal.net -P 443 -u myuser -p --ssl-mode=VERIFY_IDENTITY --ssl-cert=client.crt --ssl-key=client.key --ssl-ca=ca-bundle.crt
It's also possible to configure those arguments in the
[client] section of your
my.cnf file to be used on every connection:
#... [client] # ... ssl-mode=VERIFY_IDENTITY ssl-cert=/path/to/client.crt ssl-key=/path/to/client.key ssl-ca=/path/to/ca-bundle.crt # ...
Then, they can be dropped from the CLI client command.
$ mysql -h myserver.internal.net -P 443 -u myuser -p
All documentation content from the Hello mTLS project is licensed under Creative Commons Attribution 4.0 International (CC BY 4.0).