# User Source Automatic not creating table in MySQL DB

**URL:** <https://forum.inductiveautomation.com/t/user-source-automatic-not-creating-table-in-mysql-db/41290>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 8, 2020, 12:51pm UTC](https://forum.inductiveautomation.com/t/user-source-automatic-not-creating-table-in-mysql-db/41290 "2020-12-08T12:51:03Z")\
**Posts on this page:** 1\
**Showing post:** 12

<div class="post-metadata">

**Author:** ![jspecht](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jspecht/32/6465_2.png) [@jspecht](https://forum.inductiveautomation.com/u/jspecht)\
**Post date:** [December 8, 2020, 11:55pm UTC](https://forum.inductiveautomation.com/t/user-source-automatic-not-creating-table-in-mysql-db/41290/12 "2020-12-08T23:55:26Z")

</div>

I tested this out with a fresh install of Ignition Maker 8.1.0-final and MySQL 8.0.22 using the `mysql-connector-java-8.0.22` JDBC driver. I had no trouble adding a database connection to this DB as well as a DB User Source Profile with automatic mode set. I left the connection properties on the driver as well as the Translator settings as default the way they were installed (and it doesn’t look like these defaults have changed recently). Are you sure your JDBC driver is pointing to the correct translator and the column quote character on that translator is **`** and not **"**? When I changed my translator’s column quote character to **"** (double quote) I saw the same exact exception in my logs that you are seeing in yours.

---

_[View the full topic](https://forum.inductiveautomation.com/t/user-source-automatic-not-creating-table-in-mysql-db/41290)._