I’m failing to get a SSL connection with SQLYog to our AWS RDS MariaDB server.
In SQLYog I try to use SSL with the ca-certificate downloaded from AWS: “rds-combined-ca-bundle.pem”.
SQLYog’s response is “You are trying to connect through SSL to a server which is not configured for SSL.”
However, I have no problem to get a SLL connection with mysql.exe. There I use this command line: C:\afolder>mysql --host="serverurl" --user=user --password=secretsecret --ssl --ssl-ca=c:\certs\rds-combined-ca-bundle.pem
and the response to the command ‘status’ is:
MariaDB [(none)]> status;
mysql Ver 15.1 Distrib 5.5.45-MariaDB, for Win64 (AMD64)
Connection id: 203123
Current user: [email protected]
SSL: Cipher in use is AES256-SHA
Using delimiter: ;
Server version: 10.0.24-MariaDB MariaDB Server
Protocol version: 10
Connection: serverurl via TCP/IP