Setting up a MySQL database: for Flash designers. - Page 3

Managing Your Database

I have seen tutorials around that explain how to set up tables using a shell. Although this approach definitely has advantages and is probably 'the right' way to do it, I am going to explain a simpler way for the designer who doesn't intend on working as a system admin at night.

As a first project for your database, I highly recommend setting up a system called 'phpmyadmin'. It's a web interface for your database(s) that gives you the ability to manage your data directly from the web with a simple, easy to use interface. Follow this link: http://phpmyadmin.sourceforge.net/ and download the latest version. The installation of phpmyadmin is easy and well explained but I will go over it here also. Unzip the files and find 'config.inc.php'. Open this with a text editor (I recomend using www.editplus.com but notepad will do). Use the comments as a guide and set the database name and password according to your database that you just created. Then, ftp all the files to your web site in a directory such as '/phpmyadmin'.

That's it for phpmyadmin. Go to the directory where it has been installed that contains the 'index.php' file and you should see a variety of options for adding tables and entering queries.