# Ignition 8 - VMWare connection to MySQL Server

**URL:** <https://forum.inductiveautomation.com/t/ignition-8-vmware-connection-to-mysql-server/36548>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [July 9, 2020, 3:12pm UTC](https://forum.inductiveautomation.com/t/ignition-8-vmware-connection-to-mysql-server/36548 "2020-07-09T15:12:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jquintero](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jquintero/32/21622_2.png) [@jquintero](https://forum.inductiveautomation.com/u/jquintero)\
**Post date:** [July 9, 2020, 3:12pm UTC](https://forum.inductiveautomation.com/t/ignition-8-vmware-connection-to-mysql-server/36548/1 "2020-07-09T15:12:46Z")

</div>

Hi all.

I have ignition 8.0 installed on VMWare version 15 with NAT configuration between VM and host.

I have tried to establish two connections with the database servers that I have in the Host (SQL Server and MySQL Server)

With SQL Server I have no problem establishing the connection it works the first time.

However, with MySQL I have not been able to connect to the server (this server is in the default configuration user: root/port: 3306)

In the ignition gateway, I already have the connector to the MySQL database installed but even though I try to establish a connection the state always remains in failure

MySQL Configuration  
User: root  
port: 3306

 ![GatewayConfig](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/8/48a15c2019f7128f3ae03a5cee6c64417e7bb8c5.png) ![MySQL](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/6/661104bdbf29d1849ec772d3b9b86d9166d57e2d.png) ![Status](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/7/f771f4cb86c4c43572f189e41a8dff424681fe33.png) ![Status2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/2/62e02feae8bdd06f76f68767f352bb3fa82f3318.png)

---

<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:** [July 9, 2020, 4:48pm UTC](https://forum.inductiveautomation.com/t/ignition-8-vmware-connection-to-mysql-server/36548/2 "2020-07-09T16:48:01Z")

</div>

Is the mysql server “bound” to `0.0.0.0`, or just localhost? I believe by default MySQL will only accept connections from localhost.

---

<div class="post-metadata">

**Author:** ![jquintero](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jquintero/32/21622_2.png) [@jquintero](https://forum.inductiveautomation.com/u/jquintero)\
**Post date:** [July 20, 2020, 6:49pm UTC](https://forum.inductiveautomation.com/t/ignition-8-vmware-connection-to-mysql-server/36548/3 "2020-07-20T18:49:54Z")

</div>

Hi is bound to localhost.  
I really don’t know how to change the default connections in MySQL Server

---

<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:** [July 20, 2020, 7:01pm UTC](https://forum.inductiveautomation.com/t/ignition-8-vmware-connection-to-mysql-server/36548/4 "2020-07-20T19:01:20Z")

</div>

You need to create or edit a MySQL configuration file (`my.cnf`, `my.ini`, something like that) to specify a different bind address, then restart the server.  
This link is old, but the file locations should be largely the same: [https://stackoverflow.com/questions/14597884/mysql-my-ini-location](https://stackoverflow.com/questions/14597884/mysql-my-ini-location)