JDBC Tutorials - Herong's Tutorial Notes
Dr. Herong Yang, Version 2.11

MySQL 5.0 Download, Installation and Start

This section describes how to download, install and start MySQL server on Windows systems.

MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local Windows system very easily. Here is what I did to download and install MySQL 5.0 Community Server on my Windows system:

  • Go to MySQL 5.0 MySQL 5.0 Community Server download page.
  • Select the "Windows" and "Without installer" version.
  • Find a mirror site and download "mysql-noinstall-5.0.45-win32.zip". The file size is about 51 MB.
  • Unzip the file, you will get a new sub-directory, ".\mysql-5.0.45-win32".
  • Move and rename this sub-directory to \local\mysql.
  • The installation is done and your MySQL server is ready.

To start the MySQL server, you can run the "mysqld" program in a command window as shown in the following tutorial:

C:\>cd \local\mysql\bin
C:\local\mysql\bin>mysqld

"mysqld" will run quietly without printing any message in you command window. So you will see nothing after entering the "mysqld" command. You should trust "mysqld" and believe that MySQL server is running ok on your local computer now.

Another way to start the MySQL server is double-click \mysql\bin\mysqld.exe on your file explorer window.

Sections in This Chapter

MySQL 5.0 Download, Installation and Start

mysqladmin - MySQL Admin Tool

mysql - Command Line Tool

Creating Database and User with MySQL Monitor

Dr. Herong Yang, updated in 2007
MySQL 5.0 Download, Installation and Start