Adding MySQL Access Hosts  Print this Article

In Cpanel, a network administrator allows external web servers to access the MySQL database adding the names in the list of the hosts. Here the host or local host is the primary server on which the site is currently running. Find below are the steps to execute the process.

  •     To access the MySQL Account Maintenance Menu, click on the icon above the words MySQL Databases on the main screen of your cPanel interface.
  •     Type the name of the server into the blank field next to Host
    It should be in the following format: 192.168.1.1, server.com, mysql.servers.com etc.
  •     Click on Add Host to allows that server to access your MySQL databases.

Was this answer helpful?

Related Articles

Removing A MySQL User In Cpanel
In a scenario if you are not willing to delete the user from the database directly, you may...
Grant User's Permission to database
Once a network administrator creates a MySQL user, they must assign several permissions to those...
Creating A MySQL Database
In order to avail seamless database functionalities, administrators create highly effective...
How To Remove A MySQL Database
Hosting experts suggest that you must remove any instance of MySQL from the server which are not...
Changing MySQL database collation
To overcome foreign character encoding issues you may change the MySQL collation in. Most obvious...