Cabrillo College: Installing MySQL

Quick Index

Instructor's Page

Home
WebCT

Announcements
Schedule

Syllabus
Expectations

Help
FAQ's
How To's

Samples
Links

Hide Navigation

Installing MySQL

Overview

This document describes how to install MySQL, and various utilities, that we will be using during the course.

About MySQL

MySQL is a free (under GPL) database server that run's on most PC's. It has become popular due to its speed, compactness and low cost. You can view the MySQL Licensing Policy by clicking here.

Install MySQL

You will need to install the Max version of MySQL to support transactions. The installation steps are:

If needed, download and install Winzip from here. Use "classic" mode.
Download the software distribution for Windows binaries into C:\MySQL\ from one of the following sites.

MySQL.com (Sweden)
HurricaneElectric.net (San Jose)
ValueClick.com (L.A.)

Open the download in WinZip and install MySQL by double-clicking on setup.exe.
Locate WinMySQLAdmin.exe in C:\MySQL\bin folder and launch it.
Fill in login and passwords shown below for computers in the class room and click the OK button. At home, you may select your any login and password you like.

Login: admin
Password: guest

To allow manual control over the startup of the database server, move the WinMySQLadmin icon from C:\Windows\Start Menu\Programs\StartUp to the desktop by dragging it.

If you need more details, see the MySQL documentation or the ZDNet instructions.

Install MyCC

MyCC is a GUI Control Client for MySQL. For installation and use instructions see the lesson on Introducing MyCC

Install MyODBC

If needed, download and install Winzip from here. Use "classic" mode.
Download the appropriate MyODBC driver into C:\MySQL\ from one of the following sites:

MySQL.com (Sweden)
HurricaneElectric.net (San Jose)
ValueClick.com (L.A.)

Open the download in WinZip and install the driver by clicking on setup.exe. Make certain to select the MySQL driver before clicking the OK button.

Select MySQL before clicking OK button

In case trouble with installation, restart Windows in safe mode (press F5 or F8 when starting Windows) and then run setup.exe.

More information about MyODBC is available here.

Quick Configuration for Transactions

To use transaction, you need to use the InnoDB tables available in mysqld-max. We will need to start mysqld-max from the command line the first time so we can view the messages. On later startups, me can adjust the WinMySQLAdmin tool to use mysqld-max on the my.ini Setup tab.

From the Start menu, select Run...
Type command in the textbox and press Enter or click OK
At the DOS prompt, type cd \mysql\bin and press the Enter key
Now that you are in the right directory, type mysqld-max --standalone and press the Enter key
Verify that your results are similar to the following:

C:\MySQL\bin>mysqld-max --standalone
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
InnoDB: Setting file .\ibdata1 size to 64 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
020119 13:24:46  InnoDB: Started

C:\MySQL\bin>

To stop the server, at the DOS prompt type mysqladmin shutdown and press the Enter key.

Note that these instructions provide a default configuration and not an optimized configuration. We will cover optimizing configurations during the course.