# MySQL Connection Faulted

**URL:** <https://forum.inductiveautomation.com/t/mysql-connection-faulted/19225>\
**Category:** Ignition\
**Created:** [August 13, 2018, 3:02pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-faulted/19225 "2018-08-13T15:02:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![thaynarasant.pol](https://avatars.discourse-cdn.com/v4/letter/t/dbc845/32.png) [@thaynarasant.pol](https://forum.inductiveautomation.com/u/thaynarasant.pol)\
**Post date:** [August 13, 2018, 3:02pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-faulted/19225/1 "2018-08-13T15:02:20Z")

</div>

**MySQL Database Connection Faulted**

_ **STATUS** _  
Cannot create PoolableConnectionFactory (Unknown initial character set index ‘255’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.)

How can ni solve ?

---

<div class="post-metadata">

**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\
**Post date:** [August 13, 2018, 3:24pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-faulted/19225/2 "2018-08-13T15:24:44Z")

</div>

> [@Problems connecting Ignition to MySQL](http://forum.inductiveautomation.com/t/problems-connecting-ignition-to-mysql/18175):
>
> I am receiving this error in my logs when I am trying to connect Ignition with MySQL. I have MySQL 8.0 and I believe I’ve connected to MySQL properly and obtained the right permissions. 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.getConnecti…

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [August 14, 2018, 2:00pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-faulted/19225/3 "2018-08-14T14:00:08Z")

</div>

> <https://stackoverflow.com/questions/50474156/java-sql-sqlexception-unknown-initial-character-set-index-255-received-from-s>