877-277-2477
info@capstonecourseware.com

Tool Setup Instructions

MySQL RDBMS, Version 4.1

If the course you are setting up requires MySQL 4.1, follow these instructions to set it up on the student and instructor machines. If you have questions, please contact your courseware vendor.

If an Earlier Version of MySQL is Already Installed

If you have a version of MySQL that is 4.0 or earlier, you need to check to see if you have a MySQL service installed before removing it. To do this:

Right-click on My Computer on your desktop. Choose Manage and click on the + next to Services and Applications. Click on Services. In the right-hand pane, scroll down to see if there is a service called MySQL. If there is, then it stop the service.

If you are uninstalling a version of MySQL 4.0 or earlier you will now also have to remove the service. Find the location of your MySQL installation. It is typically at "c:\mysql" or "c:\Program Files\MySQL\MySQL Server 4.x". At a DOS command prompt, change to the MySQL directory and then execute the following command:

bin\mysqld --remove

Versions of MySQL that are 4.1 or later will remove the MySQL 4.1 or later service as part of uninstalling it.

Now remove the previous version. Use Control Panel, Add or Remove Programs, and uninstall the older version of MySQL.

If the MySQL installation folder is still remaining, then delete it. Failure do this could result in a failure during the configuration step of the new install.

New Installation of MySQL

The installer link for MySQL is located at:

http://dev.mysql.com/downloads/mysql/4.1.html#Windows

Download the installer for Windows Essentials (x86), right-click on the download file and choose Install. Follow the installation instructions of the installer. Pictures are included below for strategic decision points only. The pictures might vary slightly depending on the version you install.

Choose Typical when prompted for Setup Type.

Setup Type

The installer will install MySQL, and prompt for more formation. Next, you will be asked to sign up at MySQL.com. You can choose to sign up or not.

Sign Up

When the wizard is completed, make sure Configure the MySQL Server now is checked and click on Finish.

Configure Now

When asked for configuration type, choose Standard Configuration.

Configuration

When you're asked to set the Windows options, check Install As Windows Service, Launch the MySQL Server automatically and Include Bin Directory in Windows PATH.

Windows Options

When you're asked to set the security options, type "root" for the root password.

Security

Finally, click the Execute button.

Execute

When configuration finishes, close the wizard.

To test the installation, open a new DOS command prompt and run the command-line SQL console:

mysql --user=root --password=root

You should get a mysql> prompt. Connect to the mysql database as shown below, and you should get the response shown. Then, disconnect and exit.

mysql> connect mysql;
Connection id:
Current database: mysql
 
mysql> exit;
Bye.

You can use the MySQL System Tray Monitor, if it was installed, to shut down or startup the server process.

Be sure that the instructor is aware of the location of the MySQL installation for in-class configuration and exercises.