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:

In the 1st screen, choose Standard Configuration
In the 2nd screen, check both Install As Windows Service and Include Bin Directory in Windows PATH.
In the 3rd screen, enter a new root password, and leave both Enable root access from remote machines and Create An Anonymous Account unchecked.

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