Apparently, a former DB administrator configured our main DB server (located in germany) so that only from certain IPs would be accessable. Now we just added a new host (which needs to access that data) and for the life of me I cannot get it to do it. php programs trying to connect just clock-out for about 30 seconds and then they time out with the following error:
[19-Jan-2016 13:35:51 America/New_York] PHP Warning: mysql_connect(): Connection timed out in /home/criterion/public_html/main_sms.php on line 10
I checked the IP tables and added the IP of the new client, to no avail.
Can anybody tell me WHERE is the "allowed IPs" list or something of that sort that grans or denies access to the dabase?
I did a " select * from user_privileges;" and it listed several records. The funny thing is that among the IPs listed there were not the ones that DO work. So that tells me that is not the place. I must be looking in the wrong place.