# Problems connecting Ignition to MySQL

**URL:** <https://forum.inductiveautomation.com/t/problems-connecting-ignition-to-mysql/18175>\
**Category:** Ignition\
**Tags:** ignition79, database\
**Created:** [May 25, 2018, 6:52pm UTC](https://forum.inductiveautomation.com/t/problems-connecting-ignition-to-mysql/18175 "2018-05-25T18:52:50Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**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:** [May 25, 2018, 9:21pm UTC](https://forum.inductiveautomation.com/t/problems-connecting-ignition-to-mysql/18175/2 "2018-05-25T21:21:18Z")

</div>

This is an issue with the bundled JDBC driver (MySQL 8 changed enough things that it broke backwards compatibility). A new version of the driver will be in new installs in 7.9.9, but in the short term you can install ConnectorJ from MySQL directly: [https://dev.mysql.com/downloads/connector/j/](https://dev.mysql.com/downloads/connector/j/) and install it on your system (refer to [this page](https://docs.inductiveautomation.com/display/DOC79/JDBC+Drivers+and+Translators) for more info).

At a minimum, you’ll need to change the default ‘Extra Connection Properties’ to have `zeroDateTimeBehavior=CONVERT_TO_NULL;` and probably also add `useSSL=false;allowPublicKeyRetrieval=true;`

---

_[View the full topic](https://forum.inductiveautomation.com/t/problems-connecting-ignition-to-mysql/18175)._