Creating SSL MySQL from Windows

Assumed that you will going to install OpenSSL and you wish to apply to your MySQL if you are using Windows Operating System.

1. Download OpenSSL from URL here.
2. Once installation done, add your bin folder of the OpenSSL to your Environment Variable.
3. Open command prompt.
4. Follow the command as below.
cd \
openssl
If you see the result return is “OpenSSL>”, that mean you have successfully installed.
5. Open the MySQL command and refer to the following line.
shell> md c:\newcerts
shell> cd c:\newcerts
6. Test your certificate.
shell> mysqld –defaults-file=$DIR/my.cnf &