SSH connector is for connecting to a remote server through SSH (SSH command action), SCP or SFTP (File transfer action).
Here are some tips on how to connect to MySQL with an SSL certificate. I’m not sure if the following will work with MariaDB, but it’s worth a try.
First, you have to convert the certificate to a PFX / PKCS#12 format and put it in a file or add it to a Windows certificate store.
Then you’ll have to add some additional properties on the “Custom properties” tab of the MySQL connector.
For a file-based certificate:
CertificateFile=full path to a certificate file
For a store-based certificate:
Certificate Store Location=CurrentUser
Certificate Thumbprint=thumbprint (something like 479436009a40f3017a145cf8479e7694d7aadef0)
Certificate Thumbprint is optional and should be added in case correct certificate can’t be autodetected.
EasyMorph internally use MySQL Connector/NET for it’s native MySQL connector. Please refer to the following documentation page for details: https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl-pfx.html
Please have in mind that EasyMorph use a version of Connector/Net which doesn’t support PEM Certificates so documentation page about PEM Certificates is not applicable to EasyMorph.
The other option for connecting to MariaDB with SSL certificate is to use ODBC driver and ODBC connector.