How to add MySQL access hosts in WHM?
When generating a MySQL user access to a database, you have to specify which hosts are allowed to log in as that user. The MySQL Access Hosts tool in WHM allows you to specify certain hostnames and IP addresses that should automatically be added to every user of every database on your server.
- Find the SQL Services category.
- Go to Additional MySQL Access Hosts. Enter as many additional hosts in the box as you want, one per line.
- Finish by clicking Save.
- Return to Additional MySQL Access Hosts. Find Click here link and hit it. That’s it! All accounts on the server have been updated to use the new hosts.