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