Error connecting to the MySQL server

[Antony2611]

Hello. I have the same problem and I have enabled root permissions on the mysql server, but isconnect remains false, did you create a new user in thingworx? thank you

[slangley]

Hi @Antony2611.

Apologies for the delay on this.  It was overlooked since the reply was posted to an older topic.

We probably need to look at your connection stream to validate that it is structured properly.  Assuming that is correct, you will need to validate the login credentials, host name, etc.  We would also need to validate that firewall rule is not blocking the connection, assuming it is running on a separate server.

Regards.

--Sharon

[rosharma]

verify if XXsqlXX-jdbc.jar specific to MySQL DB is placed in tomcat directory lib folder.

once that is placed conditions are ideal for connection