# MySql connection to a remote Ignition Gateway

**URL:** <https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515>\
**Category:** Ignition\
**Created:** [December 29, 2021, 2:45pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515 "2021-12-29T14:45:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashwin.m](https://avatars.discourse-cdn.com/v4/letter/a/ea666f/32.png) [@ashwin.m](https://forum.inductiveautomation.com/u/ashwin.m)\
**Post date:** [December 29, 2021, 2:45pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515/1 "2021-12-29T14:45:53Z")

</div>

If am not able to connect the gateway to a remote MySql server. Could you please help me to do the same. I checked the manual. It does not show the configuration at the server end.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 29, 2021, 2:52pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515/2 "2021-12-29T14:52:12Z")

</div>

There’s no difference in Ignition. There simply must be a network path to the database. Most would use a VPN or a private cellular APN to provide a protected path.

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [December 29, 2021, 3:12pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515/3 "2021-12-29T15:12:36Z")

</div>

By default, MySQL only allows connections from LocalHost. Check your MySQL config settings to allow the IP on the Ignition end access to the MySQL server.

---

<div class="post-metadata">

**Author:** ![ashwin.m](https://avatars.discourse-cdn.com/v4/letter/a/ea666f/32.png) [@ashwin.m](https://forum.inductiveautomation.com/u/ashwin.m)\
**Post date:** [December 29, 2021, 3:25pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515/4 "2021-12-29T15:25:39Z")

</div>

Could you help me to find the config settings. I am new to mysql

---

<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:** [December 29, 2021, 5:00pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515/5 "2021-12-29T17:00:47Z")

</div>

The docs are a good place to start: [MySQL :: MySQL 8.0 Reference Manual :: 5.1.2 Server Configuration Defaults](https://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html)

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [December 29, 2021, 5:48pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515/6 "2021-12-29T17:48:33Z")

</div>

Open MySQL workbench, go to Server/Users and Privileges at the top menu