Hi. When leaving some SSL parameters blank, the connection is successful, but the "launch command line" doesn't work, because the command line arguments for the blank parameters are set to empty. These arguments should be left out. Let's say I'm using only the "CA Certificate" field. When launching the command line, HeidiSQL generates this:
C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe --host="xxxx" --ssl --ssl-key="" --ssl-cert="" --ssl-ca="C:\fullpath\ca-cert.pem" --user="user" --password="****" --compress --database="database"
The output is:
SSL error: Unable to get certificate from '' ERROR 2026 (HY000): SSL connection error: Unable to get certificate
Removing these empty parameters solves the issue.
C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe --host="xxxx" --ssl --ssl-ca="C:\fullpath\ca-cert.pem" --user="user" --password="****" --compress --database="database"