How do I setup remote access to my MySQL databases?

Overview

Remote MySQL allows external web servers to access your MySQL databases by adding their domain name to the list of hosts that are able to access databases on your web site.

NOTE: "localhost" stands for the server that your site is currently on.

Steps

  1. Enter a server's host name or IP address in the "Host (% wildcard is allowed)" text box.
  2. Click on the Add Host button.
  3. You will see the following statement:Click on the Go Back link.
    • "Added Host HOSTNAME to the access list."
  4.  
  5. When the page loads, you will see a two-column table containing the following information:
    • Access Hosts - This entry will include the host name or IP address.
    • Remove - Click on the x in a circle icon to remove the "Access Hosts" from being allowed to access your MySQL database.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I create a MySQL database?

Overview MySQL databases allow you to store lots of information in an easy to access manner. The...

How do I delete a MySQL database?

Overview You can easily delete a MySQL database from your web hosting account. Follow the...

How do I create a MySQL database?

Overview There are two primary steps when creating a MySQL user. The first step is to create a...

How do I use phpMyAdmin?

Overview phpMyAdmin is a web based database administration tool specifically for managing MySQL...

How do I repair my MySQL database?

Overview You can repair your MySQL database by using the "Repair DB" feature in cPanel. Steps...