Well-Known Member
May 9, 2008
Why to do this from SSH if you have inbuilt feature available in cPanel/WHM.

Log in to WHM and find the section SQL Services. Click on the link marked "Additional MySQL Access Hosts". Specify remote MySQL IP address here.

Using the X3 cPanel theme: Login to cPanel -> Databases -> Remote MySQL -> Provide Remote MySQL IP address.

If you have firewall installed then add remote MySQL IP address in whitelist of firewall and restart the firewall.