# Ignition to MYSQL error **URL:** \ **Category:** Ignition\ **Created:** [March 20, 2022, 1:54am UTC](https://forum.inductiveautomation.com/t/ignition-to-mysql-error/57396 "2022-03-20T01:54:16Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Uchenna\_Nwaba](https://avatars.discourse-cdn.com/v4/letter/u/cab0a1/32.png) [@Uchenna\_Nwaba](https://forum.inductiveautomation.com/u/Uchenna_Nwaba)\ **Post date:** [March 20, 2022, 1:54am UTC](https://forum.inductiveautomation.com/t/ignition-to-mysql-error/57396/1 "2022-03-20T01:54:17Z")
Please help me fish out the problem java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user ‘root’@‘localhost’ (using password: YES)) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:656) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:534) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:734) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:299) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:252) at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:1096) at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:582) 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 ‘root’@‘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:828) at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:448) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:103) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:652) … 12 more ---
**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Post date:** [March 20, 2022, 2:06am UTC](https://forum.inductiveautomation.com/t/ignition-to-mysql-error/57396/2 "2022-03-20T02:06:16Z")
> [@Uchenna\_Nwaba](#): > > Access denied for user ‘root’@‘localhost’ We will need more info on your setup to help. ---
**Author:** ![Uchenna\_Nwaba](https://avatars.discourse-cdn.com/v4/letter/u/cab0a1/32.png) [@Uchenna\_Nwaba](https://forum.inductiveautomation.com/u/Uchenna_Nwaba)\ **Post date:** [March 20, 2022, 2:12am UTC](https://forum.inductiveautomation.com/t/ignition-to-mysql-error/57396/3 "2022-03-20T02:12:33Z")
I am new to ignition, I tried configuring connecting Ignition to MySQL database, but got the error. What additional info would you have me send? ---
**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Post date:** [March 20, 2022, 2:15am UTC](https://forum.inductiveautomation.com/t/ignition-to-mysql-error/57396/4 "2022-03-20T02:15:39Z")
That’s perfectly ok, but with only the error there isn’t much to go on. Are you sure you typed the right password in? What version of Ignition and MySQL and please show us how you set up your database connection. ---
**Author:** ![Uchenna\_Nwaba](https://avatars.discourse-cdn.com/v4/letter/u/cab0a1/32.png) [@Uchenna\_Nwaba](https://forum.inductiveautomation.com/u/Uchenna_Nwaba)\ **Post date:** [March 20, 2022, 2:28am UTC](https://forum.inductiveautomation.com/t/ignition-to-mysql-error/57396/5 "2022-03-20T02:28:37Z")
Ignition 8.1 and MYSQL 8.0.28. I typed in the exact username (root) and password that I used to setup MYSQL into ignition’s database configuration settings for MYSQL. Thought it would be a smooth sail. This is from Management section, users and privileges page, and root as User option ![Screenshot (1)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/7/278d5bdf7a0c8880b1c75c272a94b8893f2f69b4.png) ---
**Author:** ![Uchenna\_Nwaba](https://avatars.discourse-cdn.com/v4/letter/u/cab0a1/32.png) [@Uchenna\_Nwaba](https://forum.inductiveautomation.com/u/Uchenna_Nwaba)\ **Post date:** [March 20, 2022, 2:30am UTC](https://forum.inductiveautomation.com/t/ignition-to-mysql-error/57396/6 "2022-03-20T02:30:32Z")
Although the password on this MYSQL page above seems longer (hence different) from the one I used to login into it. ---
**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Post date:** [March 20, 2022, 2:33am UTC](https://forum.inductiveautomation.com/t/ignition-to-mysql-error/57396/7 "2022-03-20T02:33:31Z")
Did you install the driver? > [@Drivers on MySql Jar files missing](https://forum.inductiveautomation.com/t/drivers-on-mysql-jar-files-missing/28940/2): > > You’ll need to install the MySQL JDBC Driver. You can find instructions and a link to the driver here: [https://docs.inductiveautomation.com/display/DOC80/JDBC+Drivers+and+Translators](https://docs.inductiveautomation.com/display/DOC80/JDBC+Drivers+and+Translators) We used to distribute the MySQL JDBC driver with Ignition but we’ve stopped doing so as of Ignition 8 because it’s not allowed by the license. We would need to see your database connection, log into the gateway web interface \> settings \> databases \> connections \> edit All signs point to bad password though. Also its not a good practice to use the root user, you should create one for ignition to use. ---
**Author:** ![Uchenna\_Nwaba](https://avatars.discourse-cdn.com/v4/letter/u/cab0a1/32.png) [@Uchenna\_Nwaba](https://forum.inductiveautomation.com/u/Uchenna_Nwaba)\ **Post date:** [March 20, 2022, 4:08am UTC](https://forum.inductiveautomation.com/t/ignition-to-mysql-error/57396/8 "2022-03-20T04:08:10Z")
Don’t mind me, I did not use the right MYSQL database scheme name. I have fixed that, It now works. I understand the principles of database design, but just getting to be acquainted with configuration and administration. Many thanks, Josborn, particularly for your swift response, its remarkable. ---
**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:** [November 17, 2023, 4:44pm UTC](https://forum.inductiveautomation.com/t/ignition-to-mysql-error/57396/9 "2023-11-17T16:44:59Z")
Split this topic on November 17, 2023, 4:44pm UTC A post was split to a new topic: [Issues connecting to MySQL](https://forum.inductiveautomation.com/t/issues-connecting-to-mysql/82063)