Connection to MySQL with SSL server.ca

KNIME Analytics Platform
5

Hi,
the example I pointed to was a dummy example on how to set the JDBC parameter. According to the MySQL documentation the JDBC parameter should be like in your first screenshot e.g.:

clientCertificateKeyStoreUrl=file: file:path_to_keystore_file
clientCertificateKeyStorePassword= mypassword
trustCertificateKeyStoreUrl=file: file:path_to_truststore_file
trustCertificateKeyStorePassword= mypassword

If you connect to a MySQL Server 8.0.12 and earlier you also need to use this additional parameter:

useSSL=true

You can also set all trust and key store parameters via the knime.ini file e.g.:

-Djavax.net.ssl.keyStore= path_to_keystore_file
-Djavax.net.ssl.keyStorePassword= mypassword
-Djavax.net.ssl.trustStore= path_to_truststore_file
-Djavax.net.ssl.trustStorePassword= mypassword

The error message still indicates to a problem with the user rights. Can double check that the user you try to connect has the right to do so from the IP address or host name of the machine KNIME Analytics Platform is running on by executing the following query:

SELECT user,host FROM mysql.user;

Bye
Tobias

1 Like