# Connect to a MySQL server from Ignition

**URL:** <https://forum.inductiveautomation.com/t/connect-to-a-mysql-server-from-ignition/26001>\
**Category:** Ignition\
**Created:** [June 21, 2019, 5:03am UTC](https://forum.inductiveautomation.com/t/connect-to-a-mysql-server-from-ignition/26001 "2019-06-21T05:03:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![miculacristianradu](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@miculacristianradu](https://forum.inductiveautomation.com/u/miculacristianradu)\
**Post date:** [June 21, 2019, 5:03am UTC](https://forum.inductiveautomation.com/t/connect-to-a-mysql-server-from-ignition/26001/1 "2019-06-21T05:03:19Z")

</div>

Hello guys,

**I’m trying to connect to a MySQL database from Ignition.**  
**I granted the root with full privileges, selected de right driver for MySQL(jdbc driver) in Ignition Gateway** and after I save the configuration the connection status is “ **faulted** ”.  
Bellow you can see the erros showing and the configuration of db connection in Ignition.

 ![mysql](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/0e40a33c9a924d83bef3fe0a396a528baa1bdccd.png) ![mysqlodbc](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f1049e93f97f852bae42db41c2ab210458c20e3f.png) ![connection](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/513276324d10cd2ebbd2d8d9331ee5d5c844ab67.png)

Thank you in advance for the support!

---

<div class="post-metadata">

**Author:** ![miculacristianradu](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@miculacristianradu](https://forum.inductiveautomation.com/u/miculacristianradu)\
**Post date:** [June 21, 2019, 5:03am UTC](https://forum.inductiveautomation.com/t/connect-to-a-mysql-server-from-ignition/26001/2 "2019-06-21T05:03:44Z")

</div>

I mention that the database server is on my own PC.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [June 21, 2019, 2:07pm UTC](https://forum.inductiveautomation.com/t/connect-to-a-mysql-server-from-ignition/26001/3 "2019-06-21T14:07:25Z")

</div>

Can you post the text of the error?

---

<div class="post-metadata">

**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\
**Post date:** [June 21, 2019, 2:09pm UTC](https://forum.inductiveautomation.com/t/connect-to-a-mysql-server-from-ignition/26001/4 "2019-06-21T14:09:27Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/d55ff52f0a1f9dcf8c59674e3df58f9293cd33ce.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f02639aef9ea855bd35169a1f8b99179deda52de.png)

---

<div class="post-metadata">

**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\
**Post date:** [June 21, 2019, 2:11pm UTC](https://forum.inductiveautomation.com/t/connect-to-a-mysql-server-from-ignition/26001/5 "2019-06-21T14:11:05Z")

</div>

Just go to mysql workbench home screen right click on server grab JDBC connection string to clipboard and paste into ignition