MySQL version 5.0 is installed on the 'stocks' (aka ‘mysql5’) server. All students have a MySQL account and database on the 'stocks' server.
You have one database in MySQL, into which all tables have to go. The database name is the same as your username.
You can do all the setup and manipulation of your database using the PHPMyAdmin interface. Start PHPMyAdmin
Although you can create and change tables directly using this interface, it is advisable to create text files containing the commands to create tables and insert data. These canthen be executed from the interface. These text files can be created using any text editor or, better still, generated by an ER modelling tool such as QSEE.
MysSQL is easy to install either as a separate download for the main MySQL site or as part of an Apache/PHP/MySQL distribution.
Here is my experience of installing MySQL (and PHP) on Windows 2000, with IIS as the web server. Hints for Windows 2000. Please let me know of any differences with XP.
The connection details for a PHP script will require:
When connected, you must select a database:
A Workbook has been created to help you learn the basics of SQL and MySQL - see Learning SQL.
This workbook is based on the familiar EMP-DEPT database and can be queried using a web interface