# Ignition 8.0.16 and MySQL8.0

**URL:** <https://forum.inductiveautomation.com/t/ignition-8-0-16-and-mysql8-0/39914>\
**Category:** Ignition\
**Created:** [October 22, 2020, 1:18pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-16-and-mysql8-0/39914 "2020-10-22T13:18:08Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [October 22, 2020, 1:18pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-16-and-mysql8-0/39914/1 "2020-10-22T13:18:08Z")

</div>

Having an issue with a project upgraded from V7.9 to V8.0 and using MySQL8.0

Transaction groups fail with syntax error and even the database browser has issues.

Anyone seen this ?

 ![2020-10-22 09_11_13-199.198.194.6 - Remote Desktop Connection](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/c/0caa77742643b351d464d91d89b4fa6623984f4c.png)

 ![2020-10-22 09_13_52-199.198.194.6 - Remote Desktop Connection](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6b4f6f519573b8535029adda9af8bfbc9def96e9.png)

---

<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:** [October 22, 2020, 1:21pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-16-and-mysql8-0/39914/2 "2020-10-22T13:21:30Z")

</div>

Does it work if you uncheck that limit box (and maybe add your own to the end of the query)?

What version is the JDBC driver you have installed?

---

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [October 22, 2020, 1:24pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-16-and-mysql8-0/39914/3 "2020-10-22T13:24:39Z")

</div>

yes it works if Select is unchecked, no data in table, but at least column names show up.  
But main issue is historical transaction groups fail on a syntax error

 ![2020-10-22 09_23_05-199.198.194.6 - Remote Desktop Connection](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/9/594a44905ad2d096a3a61db88129a9416287bd39.png)

---

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [October 22, 2020, 1:34pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-16-and-mysql8-0/39914/4 "2020-10-22T13:34:48Z")

</div>

How would i go about finding the JBDC driver version?  
This installation was made by someone else

---

<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:** [October 22, 2020, 1:42pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-16-and-mysql8-0/39914/5 "2020-10-22T13:42:09Z")

</div>

Hmm, annoyingly it seems you have to look at the name of the JAR file on the filesystem. It will be in `$IGNITION/user-lib/jdbc` on the gateway.

---

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [October 22, 2020, 1:45pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-16-and-mysql8-0/39914/6 "2020-10-22T13:45:59Z")

</div>

Found my issue.

The MySQL translator was set to MSSQL.

this application was moved from a MSSQL install to a MySQL install.