# Gateway v7.9.9 errors when connecting to new MySQL v8.4

**URL:** <https://forum.inductiveautomation.com/t/gateway-v7-9-9-errors-when-connecting-to-new-mysql-v8-4/100551>\
**Category:** Ignition\
**Created:** [January 7, 2025, 5:59pm UTC](https://forum.inductiveautomation.com/t/gateway-v7-9-9-errors-when-connecting-to-new-mysql-v8-4/100551 "2025-01-07T17:59:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![blackdog](https://avatars.discourse-cdn.com/v4/letter/b/d26b3c/32.png) [@blackdog](https://forum.inductiveautomation.com/u/blackdog)\
**Post date:** [January 7, 2025, 5:59pm UTC](https://forum.inductiveautomation.com/t/gateway-v7-9-9-errors-when-connecting-to-new-mysql-v8-4/100551/1 "2025-01-07T17:59:47Z")

</div>

We are in the process of upgrading from v7.9 and MySQL v5.4 to v8.1 and MySQL v8.4. We still have two gateways left and one of them is accessing some of the new MySQL v8.4 server(s), which is where we get these errors:

"Cannot create PoolableConnectionFactory (Client does not support authentication protocol requested by server; consider upgrading MySQL client)"

MySQL \>v8.0 has deprecated native passwords so I've looked at setting MySQL to allow native passwords (what MySQL suggests):

I put "mysql\_native\_password=ON" in the "My.ini" file but the MySQL service fails to restart afterwards.

I was wondering if there is something I need to do to get Ignition v7.9 to use SHA2 authentication with v8.4.

---

<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:** [January 7, 2025, 6:08pm UTC](https://forum.inductiveautomation.com/t/gateway-v7-9-9-errors-when-connecting-to-new-mysql-v8-4/100551/2 "2025-01-07T18:08:39Z")

</div>

You could _try_ using a new MySQL (or MariaDB) JDBC driver on the 7.9 gateway:

> **[JDBC Drivers and Translators | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/platform/database-connections/connecting-to-databases/jdbc-drivers-and-translators#upgrade-a-jdbc-driver)**
>
> There are cases where drivers or translators may need modification.

You might have to thread the needle a bit to find a JDBC driver that's new enough to support **MySQL** 8 but old enough to run on **Java** 8 (required by the 7.9 Ignition gateway). There might also be 'additional connection properties' updates needed in the DB connection settings in Ignition.

---

<div class="post-metadata">

**Author:** ![blackdog](https://avatars.discourse-cdn.com/v4/letter/b/d26b3c/32.png) [@blackdog](https://forum.inductiveautomation.com/u/blackdog)\
**Post date:** [January 7, 2025, 7:31pm UTC](https://forum.inductiveautomation.com/t/gateway-v7-9-9-errors-when-connecting-to-new-mysql-v8-4/100551/3 "2025-01-07T19:31:23Z")

</div>

Thanks for the information. The following information was also very helpful. What I think really made the difference was his step #4!

> **[Connection Errors when configuring MySQL 8.0 Database in Ignition](https://support.inductiveautomation.com/hc/en-us/articles/360047576451-Connection-Errors-when-configuring-MySQL-8-0-Database-in-Ignition#:~:text=Note:%20On%20versions%20prior%20to,authentication%20plugin%20'caching_sha2_password)**
>
> Note: On versions prior to Ignition 7.9.9, you will continue to see an error in the Database Query Browser that it fails to list the table names with the changes made above. This error has been fix...

Step #4 said to " Reinitialize the database connection". I've seen faulted DB connections in the past be fixed with a simple "reset" (disable/enable). Maybe this should be an option on the DB Connections page?