How do I setup remote access to my MySQL databases?

Databases: Remote (MySQL)

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:
    • "Added Host HOSTNAME to the access list."
  4. Click on the Go Back link.
  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.

Was this answer helpful?

 Print this Article

Also Read

How do I create a user in MySQL?

Databases: Create MySQL UserOverviewThere are two primary steps when creating a MySQL user. The...

How do I repair my MySQL database?

Databases: Repair DB (MySQL)OverviewYou can repair your MySQL database by using the "Repair DB"...

How do I delete a user from my MySQL database?

Databases: Delete MySQL UserOverviewThere are two types of deleting users. One way is to delete a...

How do I create a MySQL database?

Databases: Create MySQL Database CLICK HERE TO VIEW THE VIDEO TUTORIAL Overview MySQL...

How do I use phpMyAdmin?

Databases: phpMyAdmin CLICK HERE TO VIEW THE VIDEO TUTORIAL Overview phpMyAdmin is a web based...