# Cannot create PoolableConnectionFactory (Communications link failure) **URL:** \ **Category:** Ignition\ **Created:** [May 31, 2021, 3:15pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-communications-link-failure/47280 "2021-05-31T15:15:31Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Post date:** [May 31, 2021, 3:15pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-communications-link-failure/47280/1 "2021-05-31T15:15:31Z")
Hello everyone, I am new to both SQL and Ignition and I am using Ignition V **8.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. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 31, 2021, 4:21pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-communications-link-failure/47280/2 "2021-05-31T16:21:04Z")
> [@pkhoshroo](#): > > Connection refused: connect That means Ignition never even got to submit any username, as the database isn't listening. If the DB is on a separate machine, you need to configure MySQL to listen to more than just localhost. After you fix that, you will certainly need to ensure Ignition is using a user name and password that exists in your database. ---
**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Post date:** [May 31, 2021, 4:41pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-communications-link-failure/47280/3 "2021-05-31T16:41:47Z")
Thank you for your response! DB is not on a separate machine. ---
**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Post date:** [May 31, 2021, 5:00pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-communications-link-failure/47280/4 "2021-05-31T17:00:58Z")
I got it working based on the information on the manual, I had to set up some extra things in my SQL workbench. [https://docs.inductiveautomation.com/display/DOC80/Installing+MySQL](https://docs.inductiveautomation.com/display/DOC80/Installing+MySQL) ---
**Author:** ![jacque\_trahan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jacque_trahan/32/58886_2.png) [@jacque\_trahan](https://forum.inductiveautomation.com/u/jacque_trahan)\ **Post date:** [January 13, 2023, 8:39pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-communications-link-failure/47280/5 "2023-01-13T20:39:34Z")
Seems like the biggest aspects not covered in the ignition university connect to MySQL video is: 1. why we must have the user name as root(explained in solution link) & 2. Setting up a scheme to be used directly to ignition.(explained in solution link) I am curious for the certification will this be acceptable as a setup or is ignition requiring something else. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 13, 2023, 9:28pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-communications-link-failure/47280/6 "2023-01-13T21:28:09Z")
If you have a question about the certification test, you should email training @ [inductiveautomation.com](http://inductiveautomation.com) and ask.