The simplest and easiest way to do this is to run MySQL external access on a separate non-standard port number. That way people can get access from outside easily if they know the port number.
Another alternative is to use something like csf or apf that allow you to whitelist connections to certain ports from certain IPs.
Another alternative is to use something like csf or apf that allow you to whitelist connections to certain ports from certain IPs.
You can perform this level of filtering with the allow_hosts.rules file using the advanced rules format. Try adding the following, with modified IP to the /etc/apf/allow_hosts.rules file then restart apf (/etc/init.d/apf restart or apf -r):
in:d=3306:s=10.2.3.11
in:d=3306:s=10.2.3.11
| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| T | SOLVED MySQL remote access | Databases | 4 | |
| M | remoteMYSQL access issues | Databases | 2 | |
| S | Which script allows remote MySQL access? | Databases | 5 | |
| E | Remote access to MySQL not working | Databases | 5 | |
|
MySQL Remote Access Hosts With Range | Databases | 10 |