Enable remote mysql
In CSF, there is an option to allow IP address in a file which is ‘csf.allow’ that allows connections from external. Please do follow the steps here for enabling remote MySQL for an IP address on a cPanel server.
Either you can white-list the IP address that you need to connect to the server or you can enable only a port for the specified IP address.
Step I : Enable the port 3306 only for the specific IP address:
This can be done in the CSF configuration file ‘/etc/csf/csf.allow‘
# vi /etc/csf/csf.allow
---
tcp:in:d=3306=x.x.x.x
---
where x.x.x.x is your IP address
Example:
[root@server ~]# cat /etc/csf/csf.allow| grep 3306
tcp:in:d=3306=11.20.11.44
OR
White-list the IP address in the CSF
#csf -a x.x.x.x
Step II : Restart CSF
#csf -r
Step III : Add the IP address in remote MySQL in cPanel
a) Navigate to Databases section in cPanel b) Click on Remote MySQL c) Add the IP address that you need to add in "Access Hosts"
That’s it!!! These are the steps to enable remote mysql connection with csf.
What is isinstance function in Python?
This is a very important fn in Python programming. It returns a Boolean stating whether the object is an instance or subclass of another object. In this post, I am going to explain about Python function “isinstance” and its different examples.
Python is a good and simple language for SysAdmins automation tasks.
How to install and configure csf on CentOS/RHEL servers?
One of the most commonly using Firewall application on Linux servers. Config Server Security & Firewall is abbreviated as CSF. CSF helps to configure server firewall easily and simply. Here CryBit is going to explain how to install CSF and configure this on your Linux servers. Installation steps are simple and easy to execute.
Installation StepsStep I : SSH to your server and do the following steps as root user.
Step II : Download CSF package. Read more…
Hi, will something like this work for OUTGOING?
tcp:out:d=3306:s=127.0.0.0
User wants his locally hosted domain to connect to an external server database on another host, via 3306.
Need to enable remote MySQL in destination server too.