Hi all, I'm having some issues connecting my database to my gateway and was hoping someone could help. I'm using Ignition 8.3.0 and attempting to connect to an internal mySQL database in which I've previously connected to and created a few tables. I'm interfacing with my database through mySQL workbench.
I have already connected to this internal database running on my PC through my office's network. I used my PC's static IP on the gateway side under database connections (since my PC is hosting the database) and 127.0.0.1 on the SQL side (though do note that my bind address was set to "*" before the troubleshooting I've gone through today). I attempted to do some work on a different network and found that I could not connect to my database. Fair enough, the alternate network assigned me a new IP and the gateway connection used a static IP to connect. I experimented with this configuration parameter, trying my PC's new IP from the alternate network, "localhost", and my PCs hostname directly. None allowed me to connect to the database. When I connected back to the first network the database connection becomes valid.
I am pretty unsavvy with databases and server connections so I'm thinking I'm overlooking something big here.
The last piece of information I find noteworthy to share initially is that I am accessing my gateway remotely. The gateway is running on a server in the office. I don't think this is affecting anything as I have no issues connecting to it but thought it was worth mentioning.
I'll include screenshots of my database connection configuration, the current port and bind-address of my database, and the user configuration and permissions that I use to try to connect
