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.
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.
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
Open MySQL workbench, go to Server/Users and Privileges at the top menu