MyConnection Server SQL SSL Support
MyConnection Server supports SSL connections to MySQL servers. SSL connections require a CA certificate and, optionally, a client certificate. You should enter in the keystore boxes the name of the Java keystore which contains the certificates. The keystore should be placed in the MyConnection Server installation directory.

If you have raw certificate files (usually ending .pem), you can create a Java keystore from them. To do so:
  1. Open a DOS prompt window (Windows) or a Terminal session (Unix)
  2. Ensure that 'keytool' is in your PATH. It is located in your Java VM's 'bin' directory.
    You should be able to type 'keystore' at the command prompt and get a response.
  3. Type keytool -import -alias mysqlServerCert -file certificate.pem -keystore truststore.keystore
    This will create a keystore called truststore from the certificate certificate.pem. You will be prompted to choose a password.
If you have any problems, just contact us - we can help!