How to allow Remote MySQL access

By default, your MySQL databases can only be accessed locally by using the hostname localhost.

If you would like to connect to your database remotely from your home or office you need to enable external access through cPanel.

To get started, login to your cPanel and click the Remote MySQL icon found under the Databases section.

Remote MySQL cpanel

Next, In the Add Access Host section, enter the domain name or IP address that you wish to add in the Host field (A).  The Comment field (B) is optional and is used to distinguish the host you’re adding.  You can leave it blank or put something like ‘office’ for example.

Remote MySQL

Click Add Host (C) to complete the setup.  You can now connect to your databases remotely.

 

  • cpanel account migration, cpanel, cpanel down, cpanel hosting
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How can I migrate my cPanels to OBHost Website Hosting?

Two separate methods exist for server-to-server migrations.  Both are managed by us to ensure...

Enabling or Disabling PHP Modules

We provide the facility to enable/disable PHP modules / libraries per account.To enable a...

How can I test or preview my website before switching DNS?

There are a few different ways to preview your site before DNS resolves. This will allow you to...

SSH Access

For security purposes, we lock down SSH access to our platform by IP address.  If you wish to...

How do I add another domain to my Hosting Account?

To add a new domain to your existing hosting account: 1. Log into your cPanel control panel2....