Categorized | News

121 Access to MySQL Tutorial

Posted on 27 January 2003 by Demian Turner

Not sure how to make use of the free MySQL database space included with your web-hosting plan? This step-by-step tutorial explains a simple way to upload data from a Microsoft Access database to the MySQL database at your ISP. The tutorial also contains a free sample application written in PHP.

Click here to read the tutorial …

Bookmark and Share

2 Comments For This Post

  1. Anonymous Says:

    OK article, but most ISP\’s wont let you have direct remote access to the db, for security reasons.

  2. Anonymous Says:

    To get this to work:

    • Make sure that you are not behind a firewall OR open port 3306 in your firewall (the standard MySQL port).
    • The user must have permission to connect to the MySQL database from outside of the web server. This permission can easily be granted by specifying % in the host field of the MySQL user table (or you can specify the IP address of your computer/network if you know it). As the previous user suggested, this is often set to ‘localhost’ for security reasons. If you are concerned about security, grant the permission, upload your data and then remove permission again.

Leave a Reply



Demian Turner's currently-reading book recommendations, reviews, favorite quotes, book clubs, book trivia, book lists



PHPkitchen recommends you also check out the following sites :

Accounting for Small Businesses

FreeAgent sign-up