Connecting to MySQL from remote website

[GEE_]

Hello,

With the help of Izzy I got everything locally working with MySQL and the broadcast software.
Now I am having a problem getting our website that is hosted on another server outside the LAN to connect to the server's database.
How the website works is that it pulls the information from the station server, such as, what is playing at the moment, Top 10, if requested, recently played, playlist and requests and a couple of other items for local viewing. The firewall is set to pass the new port set for MySQL and the music request port. These are the only two ports that need to be passed. This was already set up earlier for the server. Everything is the same here except the rebuilt server. Before the new setup I was able to access the database via the work computer on the network, I can not do this anymore.
Mainly, what I need is for the website host to be able to connect to the station database for its constant updates for the page. The last time I set this up was roughly 5 years ago, so I have a bit of a mental block on how we got things to talk to each other.
The below image is to give you an idea how things are setup and the flow of the network.

Thanks
GEE

[Izzy]

Well your database user will be tied to the Host localhost.

In phpMyAdmin create a new user for the database and in the Privileges for that user select Any Host instead of localhost.

Use that new user in your database access script from the remote location.

Your other user for localhost can be retained for your local access script.

See if that helps.

[GEE_]

Thanks again Izzy,

Just needed a kick start here to remember what I had to go through the last time with this. I tried it with Any Host at first and it worked. I changed Any Host out with the IP of the web host and it works fine. Now I think its time here for me to catch some ZZzzz before I fall into the keyboard.. It's 0341 here...


Thanks again for your help.

Cheers