Please help.... doesn't work SSL on MySQL
I using the OpenSSL 1.0 and MySql server 5.1.5 on windows 7.
I followed this MySql website
http://dev.mysql.com/doc/refman/5.0/en/secure-create-certs.html to created the ssl-ca, ssl-cert & ssl-key and edit the my.ini file but it doesn't work. the have_openssl still is Disabled.
mysql> show variables like '%ssl%';
+---------------+-----------------------------+
| Variable_name | Value |
+---------------+-----------------------------+
| have_openssl | DISABLED |
| have_ssl | DISABLED |
| ssl_ca | C:/newcerts/ca-cert.pem |
| ssl_capath | |
| ssl_cert | C:/newcerts/server-cert.pem |
| ssl_cipher | |
| ssl_key | C:/newcerts/server-key.pem |
+---------------+-----------------------------+
7 rows in set (0.00 sec)
but when I remove the ssl_cert in the my.ini. The have_openssl will be YES.
mysql> show variables like '%ssl%';
+---------------+-------------------------------+
| Variable_name | Value |
+---------------+-------------------------------+
| have_openssl | YES |
| have_ssl | YES |
| ssl_ca | /etc/mysql-ssl/ca-cert.pem |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | /etc/mysql-ssl/server-key.pem |
+---------------+-------------------------------+
7 rows in set (0.00 sec)
I don't know what happened on it and how to fix it.
Please help me to fix it.
Thank you for your help....