MySql connection to a remote Ignition Gateway

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.

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.

1 Like

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.

1 Like

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

The docs are a good place to start: MySQL :: MySQL 8.0 Reference Manual :: 5.1.2 Server Configuration Defaults

1 Like

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