# MySQL 8 on Ignition 8.1 \[Solved\]

**URL:** <https://forum.inductiveautomation.com/t/mysql-8-on-ignition-8-1-solved/53147>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [November 16, 2021, 7:58pm UTC](https://forum.inductiveautomation.com/t/mysql-8-on-ignition-8-1-solved/53147 "2021-11-16T19:58:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![yehet73190](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/yehet73190/32/68157_2.png) [@yehet73190](https://forum.inductiveautomation.com/u/yehet73190)\
**Post date:** [November 16, 2021, 7:58pm UTC](https://forum.inductiveautomation.com/t/mysql-8-on-ignition-8-1-solved/53147/1 "2021-11-16T19:58:09Z")

</div>

Hello, I'm having problems with my current database setup. I have 8.1 installed and as for mysql i currently installed the latest which is MySQL 8.

My current mysql

> mysql Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86\_64 ((Ubuntu))

When I tried to create a new database I got this error

> 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'))

Any idea how to fix this? I think I've tried almost everything, my last issues were I had to change to a native password because of granting issues etc. And this was the latest issue I'm having. At this point I want to just switch to 5.6 but I also want to be able to fix this issue.

Thank you

---

<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 16, 2021, 8:06pm UTC](https://forum.inductiveautomation.com/t/mysql-8-on-ignition-8-1-solved/53147/2 "2021-11-16T20:06:12Z")

</div>

I think you may just need to update the JDBC Driver in Ignition.

[https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators](https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators)

---

<div class="post-metadata">

**Author:** ![yehet73190](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/yehet73190/32/68157_2.png) [@yehet73190](https://forum.inductiveautomation.com/u/yehet73190)\
**Post date:** [November 17, 2021, 5:05pm UTC](https://forum.inductiveautomation.com/t/mysql-8-on-ignition-8-1-solved/53147/3 "2021-11-17T17:05:24Z")

</div>

This worked. Thank you!