SSL setup issue

[Derek Meyer]

To All:

I am attempting to setup a mysql server that does NOT validate the SSL Cert. Basically I just want SSL communication between the server and the end point using a self signed cert on a per user ID. I do not want to have to give out the CA.pem file to everyone

I have the proper entrys in the my.cfg file and when the user id is created using the REQUIRE X509 and the following is issued I get a failure

mysql -ub -pb --host=xxxx --ssl-verify-server-cert=false

the config file is

ssl-ca=/apps/opt/data_5_6/servername-ca.pem
ssl-cert=/apps/opt/data_5_6/server-cert.pem
ssl-key=/apps/opt/data_5_6/server-key.pem

alter user b require X509;

What am I doing incorrectly (would like to have it like postgress in function)

Thanks