Connecting with SSL
Date: November 30, 2006 09:18PM
I am trying to simply connect to a Mysql database using the Mysql client with SSL.
I followed the instructions in the documentation but I keep getting error 2026 (HY000).
My first question is how are the users that are defined in the database (using the GRANT statement with REQUIRE X509) and the certificate that I am using with mysql client associated? What needs to match?
my grant statement is:
GRANT ALL PRIVILEGES ON test.* TO 'client_tania'@'localhost' IDENTIFIED BY 'tania' REQUIRE X509;
The CN of the client_tania certificate is:
Is it the CN in the certificate that must be the user name defined in the GRANT statement?
How is the password used in the GRANT statement related to the certificate?
I am invoking mysql as follows:
mysql --ssl-ca=/root/openssl/6120cacert.pem --ssl-cert=/root/openssl/client_tania-cert.pem --ssl-key=/root/openssl/client_tania-private-key.pem
in my.conf, the following lines exist:
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.