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 MySQL database?

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

How do I check my MySQL database?

Databases: Check MySQL DBYou can check to see if your MySQL database is running properly using...

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 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 delete a MySQL database?

Databases: Delete MySQL DatabaseOverviewYou can easily delete a MySQL database from your web...