Expertise level: Easy
You can specify the remote hosts that are allowed to access the databases on the server.
Use this procedure to configure remote MySQL accesses:
- Log on to your WHM as root.
- Go to "SQL Services" section.
- Click on "Additional MySQL Access Hosts".
- You can enter the hostnames or IP addresses of the allowed hosts here.
- Click "Save".
Users must log into their cPanel and use the "Remote MySQL" feature to set up access from these hosts.
You can also allow connection from these hosts to all users by clicking on the "Click here!" link.
Check the relevant screen capture: