How do I use MySQL Workbench to connect to my database using SSL?
This document only applies to customers that have enabled SSL on their account. Click HERE for information on enabling SSL on your account.
1. What is SSL and why is it beneficial to me?
MySQL supports secure (encrypted) connections between clients and the server using the Secure Sockets Layer (SSL) protocol. SSL uses encryption algorithms to ensure that data received over a public network can be trusted. It has mechanisms to detect data change, loss, or replay. SSL also incorporates algorithms that provide identity verification using the X509 standard.
SSL should be used anywhere where you are communicating information that should not be public. The security of your data can be compromised easily if someone is listening to traffic between your computer and the remote server. SSL works to solve that problem.
2. Download the SSL cert files for your account:
Click HERE for a tutorial on how to download your SSL cert files.
3. Open 'Manage Server Connections' in MySQL Workbench.
3.1. Open MySQL Workbench.
3.2. Click 'Manage Connections' (under the 'Databases' toolbar in this example)
4. Click 'New' to create a new connection.
5. Enter desired 'Connection Name'.
6. Enter 'mydb.tmmlog.in' (without quotes) in the 'Hostname' box, under 'Parameters'.
7. Enter your MySQL Username in the 'Username' box, under 'Parameters'.
7.1. Your MySQL Username is located in the Account Info modal near the bottom, under 'MYSQL Information'.
*Note that for password, '[Your Password]' means that your MySQL password is the same password that you use for your login.
8. Navigate to SSL configuration.
In this example, the SSL configuration is located on the 'SSL' tab on the 'Connection' page.
9. Make sure that 'Use SSL' option is set to 'If available'.
10. Set SSL Certificate Authority File.
10.1. Browse for Certificate Authority File by clicking '...' button beside 'SSL CA File'.
10.2. Select file ending in '_ca.pem' and click 'Open'.
11. Set SSL Client Certificate File.
11.1. Browse for Client Certificate File by clicking '...' button beside 'SSL CERT File'.
11.2. Select file ending in '_cc.pem' and click 'Open'.
12. Set SSL Client Key File.
12.1. Browse for Client Key File by clicking '...' button beside 'SSL Key File'.
12.2. Select file ending in '_ck.pem' and click 'Open'.
13. Verify that configuration is correct by clicking 'Test Connection'.
*Note that you will be prompted for your Password, it is the same as your login password.
14. If you have set up everything correctly you should receive a message stating that the test was successful.
Click 'OK' to close message.
15. Click 'Close' to finalize configuration.
16. After restarting MySQL Workbench, your connection will be available.
Just click the connection to begin!