MySQL - Setting Up ODBC and SSL
From All n One's bxp software Wixi
Revision as of 14:37, 23 October 2014 by Philip Lacey (talk | contribs)
Database encryption is an important security measure and with SSL we can ensure end to end encryption.
1 Step 1: Get Open SSL onto the database server.
Open SSL is free and can be downloaded from the following link http://www.openssl.org/. Once this is installed add it to your system variables path. This can be done as follows:
- Right click my computer
- Go to properties
- Then advanced system settings
- next click environment variables
- add to the path: C:\OpenSSL-Win64\bin; or similar depending on your system.
2 Step 2: Create the certs
Create a directory on the C drive like C:\MySQLSSLCerts
Next you will need to open a command window as the admin of your machine/server. Right click on the the command window tool and select "Run as Administrator"
