# Database connection, Ingition 7.9.9, MySQL8

**URL:** <https://forum.inductiveautomation.com/t/database-connection-ingition-7-9-9-mysql8/21095>\
**Category:** Ignition\
**Tags:** database\
**Created:** [November 27, 2018, 10:05pm UTC](https://forum.inductiveautomation.com/t/database-connection-ingition-7-9-9-mysql8/21095 "2018-11-27T22:05:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![asap13](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@asap13](https://forum.inductiveautomation.com/u/asap13)\
**Post date:** [November 27, 2018, 10:05pm UTC](https://forum.inductiveautomation.com/t/database-connection-ingition-7-9-9-mysql8/21095/1 "2018-11-27T22:05:57Z")

</div>

Hi there,  
I use Ignition 7.9.9, MySQL 8, connector “mysql-connector-java-8.0.13.jar”  
I’ve got db connection status error:  
Cannot create PoolableConnectionFactory (Access denied for user ‘root’@‘localhost’ (using password: NO))

Details

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘root’@‘localhost’ (using password: NO))  
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)  
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)  
at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:242)  
at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:196)  
at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:998)  
at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:565)  
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)  
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)  
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)  
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at java.lang.Thread.run(Unknown Source)  
Caused by: java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: NO)  
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)  
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)  
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)  
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)  
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455)  
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)  
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)  
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)  
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)  
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)  
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)  
… 12 more

7.9.9 (b2018081621)  
Oracle Corporation 1.8.0\_191

Regards

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [November 27, 2018, 10:19pm UTC](https://forum.inductiveautomation.com/t/database-connection-ingition-7-9-9-mysql8/21095/2 "2018-11-27T22:19:13Z")

</div>

Have you looked into whether this has merit:

```auto
Access denied for user 'root'@'localhost' (using password: NO)

```

Is root allowed? Is the password correct? etc…

---

<div class="post-metadata">

**Author:** ![asap13](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@asap13](https://forum.inductiveautomation.com/u/asap13)\
**Post date:** [November 27, 2018, 10:25pm UTC](https://forum.inductiveautomation.com/t/database-connection-ingition-7-9-9-mysql8/21095/3 "2018-11-27T22:25:56Z")

</div>

I have another db connection, created yesterday to “demo” with “root” user and it is valid.  
Today I try to connect to another MySQL db “world”, provided with mysql and I got this error.