var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
how can i let certain ip can connect my mysql under cpanel and csf ?
my server is installed centos with cpanel and csf,
now,i want to let certain user can connect their mysql from certain ip,
is any way i can set it ?
Yes, you can allow certain IPs to connect to the Mysql port.
First of all, remove the mysql port 3306 from the list of TCPIN ports in the CSF configuration file and restart csf. This will ensure, all incoming connections to port 3306 are blocked.
Now, edit the file /etc/csf/csf.allow and place the following line:
where, ClientIP is the IP you want to allow the connection to. You can allow as many IPs you wish with the similar syntax. Save the file and restart CSF.
Lastly, grant access to those IPs from cPanel >> "Access Hosts" list.
| Server Setup | Security | Optimization | Troubleshooting | Server Migration
| Monthly and Task basis services.
: madaboutlinux[at]hotmail.com | Skype
Also, you can do the same with iptables. Allow/deny any IP address you want, to any port you want.
i check my csf setting,
about the TCP_IN,there is no 3306,
do it mean if i add 3306 on it,
all people would connect mysql from public directly with their mysql username and pasword?
it seems i need check/set two part,
the first one is firewall,let the user can access the post 3306 from client's IP.
and the 2nd one is i need to add the ip in WMM's "Additional MySQL Access Hosts".
By motyl in forum Hosting Security and Technology
Last Post: 03-09-2007, 12:26 PM
By manisha_khtri in forum Hosting Security and Technology
Last Post: 06-05-2006, 10:05 AM
By petrozza in forum Hosting Security and Technology
Last Post: 11-08-2004, 07:52 AM
By atul in forum Hosting Security and Technology
Last Post: 05-11-2004, 12:24 AM
By jackiecc in forum Web Hosting
Last Post: 02-02-2004, 04:01 PM