In this article, we will check on Additional MySQL access hosts WHM. Bobcares, as a part of our MySQL support services offers solutions to all queries, no matter how trivial.

Configuring Additional MySQL Access Hosts

Every MySQL client has to authenticate with the MySQL server for communications between them and can begin the user can start working on their database. In order to do this, the MySQL client must provide the credentials of username and password with the hostname.

If the connection is local then the server name will be “localhost” or its IP. If the connection is established remotely, then the hostname will represent the IP address or hostname of the remote MySQL server.

When the connection is remote, the IP address or server names of the machine accessing the MySQL server need to be allowed to connect.

In this article, we will allow a remote MySQL connection to establish through the WHM server. This is done by “Additional MySQL Access Hosts” inside cPanel. Let’s get going into it!

Accessing the Additional MySQL Access Hosts Feature

Initially, log into the WHM service.  After you have logged in, use the search bar option on the left side of WHM and type “Additional MySQL Access Hosts”.

When the functionality shows on the search bar. You need to click on it to access the “Additional MySQL Access Hosts” page.

On the “Additional MySQL Access Hosts”, you will find a content box. Now enter either the hostname or IP address that you want to allow to connect the database remotely. You would require to add each IP/hostname on a separate line.

After adding hostnames or IP addresses. Click on the “Save” button below the content box. Next, you will redirect to a page giving the result of what just occurred.

Finally, the option to add the IP addresses or hostnames you entered in the content box for all the cPanel users. To do so, press on the “click here” link, located on the bottom right side of the screen.

Further, you will redirect to a screen showing that the users have been updated with the entries. And remote MySQL connections can be established.

[Looking for a solution to another query? We are just a click away.]

Conclusion

To sum up, the interface allows permitting remote hosts access to MySQL® databases on the server. Or to access a remote MySQL server that you configured via WHM’s Manage MySQL Profiles interface. The system applies this list of servers to all cPanel users and MySQL users that a cPanel user owns.