Before a connection can be made to a MySQL database from an external host (server) or from an application such as MySQL Workbench or Heidi SQL, the remote IP address will need to be added in cPanel. Here we detail the steps to allow a remote MySQL connection.
Related Articles
Allow Remote MySQL Database Access
- Log into cPanel
- Navigate to Remote MySQL, located under the Databases section
- In the Add Access Host field, enter the IP address from which the connection is being made and, if desired, add a comment describing the connection in the Comment field, then click Add Host
TIP: You can use "%" as a wildcard for a range of addresses. For example, to include all addresses in the range from 174.77.92.1 to 174.77.92.255 you would add 174.77.92.%.