Connect to a MySQL server from Ignition

Ignition
1

Hello guys,

I’m trying to connect to a MySQL database from Ignition.
I granted the root with full privileges, selected de right driver for MySQL(jdbc driver) in Ignition Gateway and after I save the configuration the connection status is “faulted”.
Bellow you can see the erros showing and the configuration of db connection in Ignition.

mysql
mysql1199×108 4.16 KB
mysqlodbc
mysqlodbc1162×105 5.08 KB
connection
connection838×906 39.7 KB

Thank you in advance for the support!

2

I mention that the database server is on my own PC.

3

Can you post the text of the error?

4

image
image1920×1080 165 KB

image
image1920×1080 251 KB

5

Just go to mysql workbench home screen right click on server grab JDBC connection string to clipboard and paste into ignition