Enabling remote MySQL connections Print

  • Web Hosting, Remote MySQL
  • 18

In the interest of security, databases hosted by our web hosting service are not available for remote access by default. Clients have the ability to configure remote connections through an IP address whitelist.

If an external application, such as a game server, web application running elsewhere, or MySQL management utility tries to access the database, you may be met with the following type of error:

Access denied for user 'usernamehere'@'ip or host of client' (using password: YES)

This is easily configured with the following steps:
Step 1: Log into cPanel (web hosting control panel)
Step 2: Access the Remote MySQL module.
Step 3: Add the public IP address of whatever is connecting to the database. This may be a game server, web app, etc.
Step 4: Click Add Host.

Was this answer helpful?

« Back