We can redirect to the cPanel from within WHM here: Home > Account Information > List Accounts

If we only want to allow access for one cPanel user’s databases, then we must log into the cPanel account for that user and add the IP(s)/FQDN(s) there. On this demonstration server, only two users exist, so only two users were updated: To add remote access for all cPanel accounts, simply click “click here” in the statement at the bottom of the “Additional MySQL Access Hosts” page as shown below:Īfter clicking the ‘click here’ option to update the remote access mysql for all cPanel accounts, you will see a confirmation of the users that were updated. So, we can either grant the remote location access to all cPanel account’s databases, or we must then navigate to the cPanel for the cPanel user that requires remote access and allow access to only those databases. After you have done this, if you would like to configure access from all users’ accounts click here. Important: Users must log into cPanel and use the Remote MySQL feature to set up access from these hosts. You will notice at the bottom of this screenshot, the following is stated: The following image shows how to permit remote connections for all IPs (not recommended due to security concerns and shown for demonstration purposes only): Click “Save” when you have added the IP or fully qualified hostname.

You may use a percent sign as a wildcard, so you could add ‘192.168.%’ to this list to allow all IPs that begin with ‘192.168’. You can enter the hostnames or IP addresses of the allowed hosts here. Navigate to the “SQL Services” section and click on “Additional MySQL Access Hosts”. You would first log into WHM as the root user using the following URL first (make sure to replace yourHostName.tld with your actual server’s hostname or IP address): You must use % as a wildcard character if you require the ability to allow connections for all IPs or for a particular subset (you can not use the CDIR notation for a subset of IPs but must use the ‘%’ wildcard notation instead).

If your IP is dynamic, you may be able to inquire your ISP about the CDIR range that your IPs are assigned from, and then whitelist that instead. You will need to known advance what IP/hostname, or IPs/hostnames, require database access because you will need to specify them in the panel. It is very simple to set up remote connections in MySQL/MariaDB thanks to the WHM and cPanel interfaces.

Restricting Remote Access Further Via the Firewall.

Postgresql enable remote connections