# New MySQL Connection Faulted

**URL:** <https://forum.inductiveautomation.com/t/new-mysql-connection-faulted/35928>\
**Category:** Ignition\
**Tags:** database, ignition80\
**Created:** [June 23, 2020, 5:20pm UTC](https://forum.inductiveautomation.com/t/new-mysql-connection-faulted/35928 "2020-06-23T17:20:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![gopalsrini76](https://avatars.discourse-cdn.com/v4/letter/g/35a633/32.png) [@gopalsrini76](https://forum.inductiveautomation.com/u/gopalsrini76)\
**Post date:** [June 23, 2020, 5:20pm UTC](https://forum.inductiveautomation.com/t/new-mysql-connection-faulted/35928/1 "2020-06-23T17:20:36Z")

</div>

I New to MySQL & Ignition.

I have my Ignition 8.0.12 installed on a Windows10 64bit platform. I have downloaded the mysql-connector-java-8.0.20 file so that the SQL Driver is UP.

However when i tried to make a new database connection with my gateway username and password, i am not able to connect. I am not using the root username, as i am not sure of its password.

Do i need to Download the MySQL from Oracle website? Kindly someone support on this.

**Below are the contents of my error message.**

java.sql.SQLException: 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.)  
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2385)  
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2110)  
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1563)  
at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:257)  
at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:211)  
at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:1059)  
at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:565)  
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)  
at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source)  
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)  
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at java.base/java.lang.Thread.run(Unknown Source)  
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: 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.  
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)  
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)  
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)  
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:456)  
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)  
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)  
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53)  
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291)  
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2395)  
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2381)  
… 12 more  
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: 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.  
at jdk.internal.reflect.GeneratedConstructorAccessor83.newInstance(Unknown Source)  
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)  
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)  
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)  
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)  
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)  
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)  
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)  
at com.mysql.cj.NativeSession.connect(NativeSession.java:144)  
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956)  
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826)  
… 19 more  
Caused by: java.net.ConnectException: Connection refused: connect  
at java.base/java.net.PlainSocketImpl.waitForConnect(Native Method)  
at java.base/java.net.PlainSocketImpl.socketConnect(Unknown Source)  
at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)  
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)  
at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)  
at java.base/java.net.SocksSocketImpl.connect(Unknown Source)  
at java.base/java.net.Socket.connect(Unknown Source)  
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)  
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)  
… 22 more

8.0.12 (b2020042115)  
Azul Systems, Inc. 11.0.6

---

<div class="post-metadata">

**Author:** ![James.Lorenz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/james.lorenz/32/3290_2.png) [@James.Lorenz](https://forum.inductiveautomation.com/u/James.Lorenz)\
**Post date:** [June 23, 2020, 5:26pm UTC](https://forum.inductiveautomation.com/t/new-mysql-connection-faulted/35928/2 "2020-06-23T17:26:04Z")

</div>

Yes, you’ll need to install the actual MySQL DB yourself.

---

<div class="post-metadata">

**Author:** ![gopalsrini76](https://avatars.discourse-cdn.com/v4/letter/g/35a633/32.png) [@gopalsrini76](https://forum.inductiveautomation.com/u/gopalsrini76)\
**Post date:** [June 23, 2020, 5:32pm UTC](https://forum.inductiveautomation.com/t/new-mysql-connection-faulted/35928/3 "2020-06-23T17:32:14Z")

</div>

Hi James,

Thanks for the immediate reply.

I can install any of the MySql versions (Enterprise, Classic or Standard)?

---

<div class="post-metadata">

**Author:** ![danieltalbot](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/danieltalbot/32/11201_2.png) [@danieltalbot](https://forum.inductiveautomation.com/u/danieltalbot)\
**Post date:** [June 23, 2020, 5:57pm UTC](https://forum.inductiveautomation.com/t/new-mysql-connection-faulted/35928/4 "2020-06-23T17:57:11Z")

</div>

The community edition is free.

---

<div class="post-metadata">

**Author:** ![gopalsrini76](https://avatars.discourse-cdn.com/v4/letter/g/35a633/32.png) [@gopalsrini76](https://forum.inductiveautomation.com/u/gopalsrini76)\
**Post date:** [June 24, 2020, 7:09am UTC](https://forum.inductiveautomation.com/t/new-mysql-connection-faulted/35928/5 "2020-06-24T07:09:59Z")

</div>

Let me try that

---

<div class="post-metadata">

**Author:** ![gopalsrini76](https://avatars.discourse-cdn.com/v4/letter/g/35a633/32.png) [@gopalsrini76](https://forum.inductiveautomation.com/u/gopalsrini76)\
**Post date:** [June 24, 2020, 10:26am UTC](https://forum.inductiveautomation.com/t/new-mysql-connection-faulted/35928/6 "2020-06-24T10:26:55Z")

</div>

I have installed MySQL and configured the same and i have my database connection ready
