I am new to both SQL and Ignition and I am using Ignition V8.1.6 on a Windows10 64bit platform and I am using mysql-connector-java-8.0.25.
When I’m trying to configure a database for MySQL JDBC Driver, Connector/J, I get this error:
"Cannot create PoolableConnectionFactory (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)"
This is also the additional error message in the box:
" java.sql.SQLException: Cannot create PoolableConnectionFactory (Communications link failure
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Caused by: java.net.ConnectException: Connection refused: connect "
When I created my database I did not change any settings and I did not assign any username and password and only added a name for the database!
Does anyone know how can I fix this?
Thank you in advance for your help.