How to allow remote MySql connection to only one IP?

There may be a case in which one of the cPanel user request you to provide access to Mysql remotely. You probably can't open MySql port 3306 on the server because that would lead to security risks. So in such case follow below steps -
 
Step 1:
Login to cPanel >> Remote Mysql >> Add remote server's IP address under Add access host >> Click Add host.

Step 2 :
Open mysql port for the remote IP address. To do this update below csf file (firewall) -

nano /etc/csf/csf.allow
tcp|in|d=3306|s=x.x.x.x (Replace x.x.x.x with remote server IP)

Now, remote IP x.x.x.x will be able to access Mysql on your server.

Was this answer helpful?

 Print this Article

Also Read

How to enable root login alerts on cPanel server?

For security reasons, you would like to get an alert to your mailbox if someone logins to the...

Can't find disk space in /home directory on the cPanel server.

Before transferring a website from one server to another, I checked disk space of website using...

Fatal error: Class 'JCache' not found in /libraries/joomla/factory.php - Joomla Issue

After updating the Joomla, I was getting Fatal error: Class 'JCache' not found in...

FATAL: Failed to download updatenow.static from server: The system cannot update the /var/cpanel/sysinfo.config file. at /usr/local/cpanel/Cpanel/GenSysInfo.pm line 115 : upcp failed

You may come across the message "***** FATAL: Failed to download updatenow.static from server:...

Is it possible to add multiple backup destinations on the cPanel server?

Is it possible to add multiple backup destinations on the cPanel server?Solution :- Yes, its...

Powered by WHMCompleteSolution