MySQL Setup and Configuration for CS122

Download MySQL Community Server binary release from the mysql.com. There are several packages under the "Windows downloads" section. It's recommended that you download the one called "Windows Essentials". This package comes in as a single .msi file. Once you have the file, you may start the installation by double-clicking on the file, and follow the on-screen instructions. During the installation process, you may leave all the options to default. After the installation is completed, the MySQL configuration wizard will walk you through the configuration of the database server:
You may leave all other options to default.

Suppose that MySQL is installed under C:\Program Files\MySQL\MySQL Server 5.0, the installer would have added C:\Program Files\MySQL\MySQL Server 5.0\bin to your PATH environment variable during the second step of the configuration (Include Bin Directory in Windows PATH). On Windows 2000 you may need to log off then log in again for the environment variable to take effect.

Open a DOS prompt and execute the command
mysql -u root -p
Type in the root password you supplied during the installation process, and your should be able to see the mysql prompt:
mysql>
You may want to create a database for practicing SQL, e.g.
mysql> create database cs122;
And to exit the command line client, enter exit or \q at the mysql prompt.

If you want to use MySQL Query Browser to access your databases, follow the instructions in the CS3 Server document, but note that when you enter server host, use localhost instead of cs3.calstatela.edu.

THE END