How to add MySQL access hosts in WHM

When granting 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.

1) Find the SQL Services category.

2) Go to Additional MySQL Access Hosts.

3) Enter as many additional hosts here as you want, one per line.

4) Finish by clicking Save.

The MySQL Access Hosts have been saved, but there’s one more step that should be done.

5) Return to the same page.

In order for these additional hosts to become active, every user must log into their cPanel accounts and enter the MySQL Manager. There’s a tool here that allows you to circumvent that, if you want.

6) Click here.

That’s it! All accounts on the server have been updated to use the new hosts.

This is the end of the tutorial. You now know how to add additional MySQL access hosts in WHM.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to see details in WHM about the processes currently in use by MySQL

If you’ve noticed that MySQL seems to be responding sluggishly, one of your users may...

What is a MySQL database?

A MySQL database, like all other types of databases, is used to keep track of a website or...

How to manage MySQL user passwords in WHM

There’s a page in WHM that allows you to manage all the MySQL passwords on your system....

How to change the root MySQL password in WHM

When cPanel/WHM is set up, your system MySQL password is randomly generated. If you ever need...