# Ignition 8.1.28 and MySQL 8.0 - setup connections not working **URL:** \ **Category:** Ignition\ **Tags:** database\ **Created:** [June 9, 2023, 9:07pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862 "2023-06-09T21:07:24Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\ **Post date:** [June 9, 2023, 9:07pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/1 "2023-06-09T21:07:24Z")
Trying to setup Ignition to access a database on the local host. Keep getting error messages for unauthenticated cache.sha2.password or poolable connection factory.. class java.math.Biginteger. the user manual seems to skip a few steps. ---
**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:** [June 9, 2023, 9:08pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/2 "2023-06-09T21:08:58Z")
Let's start with a copy/paste of the full error stack trace text. ---
**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\ **Post date:** [June 9, 2023, 9:13pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/3 "2023-06-09T21:13:44Z")
This is one of them java.sql.SQLException: Cannot create PoolableConnectionFactory (Unable to load authentication plugin 'caching\_sha2\_password'.) 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:300) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:253) 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:587) 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: Unable to load authentication plugin 'caching\_sha2\_password'. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:923) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1725) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:822) at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) at jdk.internal.reflect.GeneratedConstructorAccessor111.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.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317) 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:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\ **Post date:** [June 9, 2023, 9:14pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/4 "2023-06-09T21:14:46Z")
and this is the other one java.sql.SQLException: Cannot create PoolableConnectionFactory (java.lang.ClassCastException: class java.math.BigInteger cannot be cast to class java.lang.Long (java.math.BigInteger and java.lang.Long are in module java.base of loader 'bootstrap')) 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:300) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:253) 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:587) 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: java.lang.ClassCastException: class java.math.BigInteger cannot be cast to class java.lang.Long (java.math.BigInteger and java.lang.Long are in module java.base of loader 'bootstrap') at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1062) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3556) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2513) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:822) at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) at jdk.internal.reflect.GeneratedConstructorAccessor111.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.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317) 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 Caused by: java.lang.ClassCastException: class java.math.BigInteger cannot be cast to class java.lang.Long (java.math.BigInteger and java.lang.Long are in module java.base of loader 'bootstrap') at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1007) ... 27 more ---
**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:** [June 9, 2023, 9:18pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/5 "2023-06-09T21:18:05Z")
I think you may need to upgrade the MySQL JDBC driver. [https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators#JDBCDriversandTranslators-UpgradeaJDBCDriver](https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators#JDBCDriversandTranslators-UpgradeaJDBCDriver) [https://dev.mysql.com/downloads/connector/j/](https://dev.mysql.com/downloads/connector/j/) ---
**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\ **Post date:** [June 9, 2023, 9:19pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/6 "2023-06-09T21:19:09Z")
i will give a try, thanks ---
**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\ **Post date:** [June 9, 2023, 9:41pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/7 "2023-06-09T21:41:33Z")
Already had the latest and greatest ---
**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:** [June 9, 2023, 9:52pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/8 "2023-06-09T21:52:59Z")
Hmm, not sure. Screams JDBC / MySQL version mismatch to me. QA is going to spin something up with the latest MySQL JDBC and server to sanity check. ---
**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:** [June 9, 2023, 10:02pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/9 "2023-06-09T22:02:47Z")
No issue with 8.0.33... might want to call support and let them take a look. ---
**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\ **Post date:** [June 12, 2023, 12:35pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/10 "2023-06-12T12:35:59Z")
thanks ---
**Author:** ![Jared\_E\_82](https://avatars.discourse-cdn.com/v4/letter/j/59ef9b/32.png) [@Jared\_E\_82](https://forum.inductiveautomation.com/u/Jared_E_82)\ **Post date:** [June 15, 2023, 5:35pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/11 "2023-06-15T17:35:33Z")
Is there any update on this? I have the exact same issue, same error. ---
**Author:** ![apena](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/apena/32/84441_2.png) [@apena](https://forum.inductiveautomation.com/u/apena)\ **Post date:** [June 15, 2023, 5:45pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/12 "2023-06-15T17:45:17Z")
There is a Knowledgebase article [here](https://support.inductiveautomation.com/hc/en-us/articles/360047576451-Connection-Errors-when-configuring-MySQL-8-0-Database-in-Ignition) walking you through how to get your MySQL 8 database connected in Ignition. In addition to updating to the latest JDBC driver, there are Extra Connection Properties that need to be changed. ---
**Author:** ![Jared\_E\_82](https://avatars.discourse-cdn.com/v4/letter/j/59ef9b/32.png) [@Jared\_E\_82](https://forum.inductiveautomation.com/u/Jared_E_82)\ **Post date:** [June 15, 2023, 6:09pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-and-mysql-8-0-setup-connections-not-working/74862/13 "2023-06-15T18:09:42Z")
Thanks so much. I had all the correctly installed components but I had not yet made any modifications to JDBC driver or existing Database I had already setup in Ignition. That seems to have fixed me right up, thanks!