To create SSL connection the following three files are required:
You need to specify their location in my.ini file of the MySQL server and on the Security tab of the Database Connection Properties dialog box.
d:
cd \openssl
openssl genrsa 1024 > ca-key.pem
(This string will create ca-key.pem file)
openssl req -new -x509 -nodes -days 1000 -key ca-key.pem -config myssl.cnf > ca-cert.pem
(This string will create ca-cert.pem file.)
openssl req -newkey rsa:1024 -days 1000 -nodes -keyout server-key.pem -config myssl.cnf > server-req.pem
(This string will create server-key.pem file.)
openssl x09 -req -in server-req.pem -days 1000 -CA ca-cert.pem -CAkey ca-key.pem -set_serial 01 > server-cert.pem
(This string will create server-cert.pem file.)
openssl req -newkey rsa:1024 -days 1000 -nodes -keyout client-key.pem -config myssl.cnf > client-req.pem
(This string will create client-key.pem file.)
openssl x509 -req -in client-req.pem -days 1000 -CA ca-cert.pem -CAkey ca-key.pem -set_serial 01 client-cert.pem
(This string will create client-cert.pem file.)
Relocate the generated files on your machine if required, and go to the installation directory of the MySQL Server. Open the my.ini file and after [mysqld] line specify the location of the generated files - ca-cert.pem, server-cert.pem, and server-key.pem by typing:
ssl
ssl-ca=”D:/SSL Certificates/ca-cert.pem”
ssl-cert=”D:/SSL Certificates/Server/server-cert.pem”
ssl-key=”D:/SSL Certificates/Server/server-key.pem”
Restart the MySQL Server and check if it supports SSL by opening a new SQL document in dbForge Query Builder for MySQL - (in the top menu, select SQL expanding the New node of the File menu) and typing the following:
SHOW VARIABLES LIKE have_openssl