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.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

JFolder::create: Could not create directory - Warning! Failed to move file. Unable to find install package - Joomla Issue

While installing Extension in Joomla I was getting below error message - JFolder::create: Could...

Host1 uid 32210 no header by parse_headers so taking whole header with BODY.PEEK[HEADER]

I was getting below error messages while using imapsync command on the server and emails were not...

How to configure Amazon S3 backups in WHM?

There is always issues on the server like Hard Drive Failures and its very important to keep your...

Error displaying the error page: The cachelite Cache Storage is not supported on this platform. (Joomla error)

While accessing the Joomla site, I was getting error as - Error displaying the error page: The...

requires the ionCube PHP Loader ioncube_loader_lin_5.2.so to be installed by the website operator

I was getting below error while installing Softaculous on the cpanel server -. requires the...

Powered by WHMCompleteSolution