Difference between revisions of "MySQL - Setting Up ODBC and SSL"

From All n One's bxp software Wixi

Jump to: navigation, search
Line 13: Line 13:
  
 
== Step 2: Create the certs ==
 
== 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"

Revision as of 14:37, 23 October 2014

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"

Retrieved from ‘https://www.bxpsoftware.com/wixi/index.php?title=MySQL_-_Setting_Up_ODBC_and_SSL&oldid=2026’