When using SequelPro, I have to check "Connect using SSL" option to connect to a remote mysql database server, but without providing "Key File", "Certificate" or "CA Cert", which is shown as the screenshot below:
Is there an equivalent way to do it in mycli? Or just plain mysql
command?
It's the --ssl
option, which means "Enable encrypted connection".
mysql --ssl
A full list of command-line flags for MySQL CLI (mysql
) can be found here:
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-options.html
I don't believe that that checkbox does anything as fancy as verifying certificates (i.e. it does not pass in the --ssl-verify-server-cert
option).