# Mysql data base connection

**URL:** <https://forum.inductiveautomation.com/t/mysql-data-base-connection/56645>\
**Category:** Ignition\
**Created:** [February 28, 2022, 8:17pm UTC](https://forum.inductiveautomation.com/t/mysql-data-base-connection/56645 "2022-02-28T20:17:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ray\_Guthrie](https://avatars.discourse-cdn.com/v4/letter/r/f475e1/32.png) [@Ray\_Guthrie](https://forum.inductiveautomation.com/u/Ray_Guthrie)\
**Post date:** [February 28, 2022, 8:17pm UTC](https://forum.inductiveautomation.com/t/mysql-data-base-connection/56645/1 "2022-02-28T20:17:38Z")

</div>

I get a faulted status when I create mySQL data base. see description as follows:java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user ‘admin’@‘localhost’ (using password: YES))  
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: java.sql.SQLException: Access denied for user ‘admin’@‘localhost’ (using password: YES)  
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)  
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)  
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:829)  
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:449)  
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:242)  
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)  
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

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [February 28, 2022, 9:53pm UTC](https://forum.inductiveautomation.com/t/mysql-data-base-connection/56645/2 "2022-02-28T21:53:03Z")

</div>

> [@Ray\_Guthrie](#):
>
> java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user ‘admin’@‘localhost’ (using password: YES))

Welcome @Ray_Guthrie  
Looks like your credentials are incorrect for connecting to the database. Assuming you are using a GUI like mySQL workbench or HeidiSQL, go to the user manager section and review your user credentials. Most of the time, the mySQL default login user is root not admin.

---

<div class="post-metadata">

**Author:** ![Ray\_Guthrie](https://avatars.discourse-cdn.com/v4/letter/r/f475e1/32.png) [@Ray\_Guthrie](https://forum.inductiveautomation.com/u/Ray_Guthrie)\
**Post date:** [February 28, 2022, 10:28pm UTC](https://forum.inductiveautomation.com/t/mysql-data-base-connection/56645/3 "2022-02-28T22:28:17Z")

</div>

Can I reset mysql password from work bench if I don’t know my current password?

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [February 28, 2022, 10:57pm UTC](https://forum.inductiveautomation.com/t/mysql-data-base-connection/56645/4 "2022-02-28T22:57:30Z")

</div>

Yes you can. Just google reset mySQL password. Also, I think mysql does not have a default password so setup one and you should be good to go.