MySql Database access restricted by IP address?
Posted by:
Bill Jour
Date: October 02, 2017 08:44AM
Hello Forum....I did a search for this topic but haven't been able to find anything similar. The issue is that access to the MqSql database records via a PHP page interface has been restricted by the former programmer...I am assuming that he did this by restricting access by only allowing IP addresses in a certain range.
What is happening is that only an IP address in the 200 range in the fourth subset can get access....for example, a workstation with IP address 192.168.1.200 and higher (201, 202, 203, etc.) will be able to access while anything below 200 (192.168.1.199, 198, 197, etc.) gets a denied access message.
I will soon have to make changes to the Static IP address, Netmask and Gateway of the MySql server in the etc/network/interfaces file...it is running Debian Linux. The present static IP address is 192.168.1.240.....this will need to be changed to 192.168.6.7 in the next week to ten days. I anticipate that any workstation trying to access the MySql database after those changes are made will get a denied access message because of the IP address restriction.
My question is where can I look to find the configuration file that contains the IP address restriction so that I can edit it to conform to the changes I make in the interfaces file.
Hope this all makes sense. Thanks!