What is the equivalent of sequel pro's just ch

2019-02-26 00:07发布

问题:

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?

回答1:

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).