# Caching\_sha2\_password

**URL:** <https://forum.inductiveautomation.com/t/caching-sha2-password/19099>\
**Category:** Ignition\
**Created:** [August 4, 2018, 7:43am UTC](https://forum.inductiveautomation.com/t/caching-sha2-password/19099 "2018-08-04T07:43:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jtooley](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jtooley](https://forum.inductiveautomation.com/u/jtooley)\
**Post date:** [August 4, 2018, 7:43am UTC](https://forum.inductiveautomation.com/t/caching-sha2-password/19099/1 "2018-08-04T07:43:51Z")

</div>

Has anyone else had the following problem when connecting Ignition to MySQL8.0.4?

> Cannot create PoolableConnectionFactory (Unable to load authentication plugin 'caching\_sha2\_password'.)

Has anyone managed to get Ignition to connect and if so how? I am unable to change the user authentication from caching\_sha2\_password.

---

<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:** [August 4, 2018, 10:47pm UTC](https://forum.inductiveautomation.com/t/caching-sha2-password/19099/2 "2018-08-04T22:47:57Z")

</div>

At the very least you have to install a newer JDBC driver for MySQL 8. I'm not sure if there's anything else needed.

> [@MySQL 8.0 Connection](http://forum.inductiveautomation.com/t/mysql-8-0-connection/17848):
>
> Anyone install MySQL 8.0 and connect with Ignition? I get an error when I attempt. Wondering if maybe the java MySQL driver needs to be updated to work… org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) a…

---

<div class="post-metadata">

**Author:** ![craigb](https://avatars.discourse-cdn.com/v4/letter/c/9f8e36/32.png) [@craigb](https://forum.inductiveautomation.com/u/craigb)\
**Post date:** [August 5, 2018, 11:11am UTC](https://forum.inductiveautomation.com/t/caching-sha2-password/19099/3 "2018-08-05T11:11:56Z")

</div>

> [@jtooley](#):
>
> caching\_sha2\_password'

Copied from another forum but I had the same issue and this fixed it. I found this with the same error, when trying to remove sha2 from the user profile in the workbench it would enable it straight away when I applied the changes. Once I did the below in the preferences I was then able to remove sha2 In workbench and apply it. Then ignition connected to it.

Open MySQL from System Preferences \> Initialize Database \>  
Type your new password.  
Choose 'Use legacy password'  
Start the Server again.  
Now connect the MySQL Workbench

---

<div class="post-metadata">

**Author:** ![jtooley](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jtooley](https://forum.inductiveautomation.com/u/jtooley)\
**Post date:** [August 6, 2018, 6:07am UTC](https://forum.inductiveautomation.com/t/caching-sha2-password/19099/4 "2018-08-06T06:07:27Z")

</div>

Thank you.

I did that and it came up with a different error message that I managed to resolve by updating the drive to mysql-connector-java-5.1.46.

---

<div class="post-metadata">

**Author:** ![bryankm](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@bryankm](https://forum.inductiveautomation.com/u/bryankm)\
**Post date:** [September 2, 2018, 1:21pm UTC](https://forum.inductiveautomation.com/t/caching-sha2-password/19099/5 "2018-09-02T13:21:32Z")

</div>

I had the same issue and the following article resolved the problem.

[https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/125/0/connection-errors-when-configuring-mysql-80-database-in-ignition](https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/125/0/connection-errors-when-configuring-mysql-80-database-in-ignition)