Adding an access-host to MySQL

Mostly, you will only need to access your database directly from scripts within your webspace. Occassionally, you may need access to your database from another machine such as your computer or another server. In this situation you must add an access-host to MySQL, because access from the outside is blocked by default. This demonstration shows how to add an access-host to MySQL.

Simply follow the simple instructions below.

  1. Select the MySQL Databases link.
    Top of page
  2. Enter the host you wish to allow access to MySQL from in this box, for example,
    • An internet IP address: 72.14.207.99,
    • A hostname: yourwebhost.com,
    • A hostname or IP address using the wildcard: 72.14.207.%,
    • Click the Add Host button.

    Top of page
  3. Well Done! You have successfully added an Access-Host to MySQL.
    Top of page