Background:
I'm trying to log in via command line to a mysql database set up by one of our admins. I see that they have ssl enabled because when I try to connect i get this message: mysql --user=root --password=test testdb ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1)
What I've Checked So far:
I've checked the my.cnf file for the ssl settings: [client] #password = your_password port = 3306 socket = /var/run/mysqld/mysqld.sock ssl-ca = /etc/ssl/ca-self-cert.pem ssl-cert = /etc/ssl/server-self-cert.pem ssl-key = /etc/ssl/server-self-key.pem [mysqld] ... server-id = 100 relay-log = mysqld-relay-bin ssl-ca = /etc/ssl/ca-self-cert.pem ssl-cert = /etc/ssl/server-self-cert.pem ssl-key = /etc/ssl/server-self-key.pem
I tried changing the login command to look this this instead: mysql --user=root --password=test testdb --protocol=TCP --ssl-ca=/etc/ssl/ca-self-cert.pem ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (111)
and also: mysql --user=root --password=test testdb --protocol=TCP --ssl-ca=/etc/ssl/ca-self-cert.pem --host=10.123.123.123 ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1)
The value I've specified for host matches what is set up as the bind-address in my.cnf
I'm still google more to find other articles / posts. But so far, I haven't been able to find a solution.
Any suggestions would be appreciated.
ps. I do know that the database itself is ok because the web application that connects to it is working fine. I just need to be able to connect so I can do a dump of the database.