From the databases page, I was able to successfully connect to a remote MySQL db (on Azure) without SSL, but could not find a way to config aaPanel / mySql to use a secure SSL connection. I tried installing a local cert and then adding it to my.cnf but nothing worked.
Has anyone done this successfully?
Hello, can you paste what configuration you added? Should I restart mysql after adding?
my.cnf
[client]
host=mysqldbname.mysql.database.azure.com
user=sadmin
password=mysqlpassword
ssl-ca=/etc/mysql/certs/ca.pem
tried updating all mysql config files on machine and then re-started.
but i have no idea is this is the right approach
Hello, you need to configure it in the [mysqld] block Reference:
[mysqld]
ssl-ca=/www/server/mysql/mysql-test/std_data/cacert.pem
ssl-cert=/www/server/mysql/mysql-test/std_data//server-cert.pem
ssl-key=/www/server/mysql/mysql-test/std_data/server-key.pem