Install MySQL on Windows

We'll look at three stages: downloading, installing, and starting the server.

Downloading MySQL

The first step to installing MySQL on Windows is to download the installation file. Open your browser and browse to http://www.mysql.com/downloads/index.html, which is the MySQL downloads page. You need to select the option MySQL 3.23 Production release (recommended). This will take you to a new page where you can select the package to download. For Windows, there's only one file, which at the time of writing is listed as

Windows 95/98/NT/2000/XP Version 3.23.55 Size 13.3M

Download this file ready for the install by selecting the "Pick a mirror" link, so you can choose the download location closest to you. New versions are released frequently, but the actual setup procedure should remain the same.

It is worth noting that a new version of MySQL (version 4) is under development and at the time of this writing is still undergoing testing. You can find out more about the MySQL version 4 release at the following URL: http://www.mysql.com/doc/en/MySQL_4.0_In_A_Nutshell.html.

Installing MySQL

The downloaded install file is a .zip file, so you'll need to extract the contents of this file to a temporary location on your hard drive. Run the setup program by double-clicking setup.exe. This will start the install process.

Click Next to start the installation.

This dialog box gives extra information about the installation. It's important to read this information in case it applies to your installation. You can then click Next to continue.

In the next dialog box, you can select the directory into which MySQL is installed. It's recommended that you leave this directory as the default, which is C:\mysql. If you change it, you will need to configure MySQL later to use your chosen path.

Click Next to continue to the next dialog box, which allows you to select an installation type. It's recommended that you stick to the default option. Click Next to continue and then Finish to complete the installation.

Starting the MySQL Server

Now that the MySQL server package has been installed, you need to start the server before you can perform any administration tasks and set up a new database. To start the server, open Windows Explorer and browse to the directory in which you installed MySQL. If you followed this guide, then the location is C:\mysql.

Next, change to the bin subdirectory. Here you should see a tool called winmysqladmin.exe. This is used to start and stop the MySQL server, so to make it easier to get to, it's a good idea to right-click the winmysqladmin.exe file and select Create Shortcut. You can then drag this shortcut to the desktop to make it more accessible and easier to control the MySQL server.

To start the server, double-click the winmysqladmin.exe file. The first time you run WinMySQLAdmin, it will prompt you for a username and password, which it will store in a file called my.ini in your Windows system directory and use to access MySQL information.

The dialog box shown next will appear briefly and will then disappear.

Note that the Environment tab, shown in the preceding screen shot, is useful for displaying information about the MySQL server. When the preceding dialog box has minimized, you'll be left with a green "traffic light" icon in your Windows System tray. This indicates that the MySQL server is running.

If the icon is red, the MySQL server is stopped.

If you right-click the MySQL "traffic light" icon and select Show me, the main winmysqladmin.exe screen is redisplayed. This tool allows you to see various categories of information about the server, such as the databases set up and how many users are connected to MySQL.

To start and stop the MySQL server, you can either right-click the MySQL icon in the system tray and use the menu to stop or start the server, or you can use the Services section of Administrative tools in the Windows Control Panel.

Now the server is installed and running.

1. Installing PHP for IIS
In this tutorial we'll describe how to add PHP functionality to IIS, so that you can use IIS to serve PHP pages. We assume that at this stage that your IIS server is se...

2. The Apache Web Server
There are currently two different versions of Apache: the original 1.3.x series and the newer Apache 2.x series. In this guide, we're going to look at the latest versio...

3. How to Configure a NTP Network Time Server in Windows 2000
Summary: This article describes how to configure Windows 2000 to act as an authoritative time server using NTP (Network Time Protocol). Computer time synch...

4. Are Used Cisco switches worth buying
Buying new things all the time can be a great fun. Seeing every bit of computer equipment looking new and shiny can be very satisfying. With the recession in full swing at ...

5. What is Web server Log File Analysis
A log file is a file that stores all the actions in an order that occurred with a server, a device, an application. Log file is like a "black box" in an aircraft, but only ...

6. What is a Server
Server describes a function rather than a particular PC technology or design. A server is a computer that provides resources that can be shared by other computers. Thos...

7. What is a Network Computer
The opposite direction for the home PC is one stripped of power instead of enhanced. Instead of being a general purpose machine, this sort of home PC would be particularl...

8. Why network administrators need a network bandwidth monitor
Every network admin should monitor network bandwidth and traffic usage in his local network to use the enterprise resources efficiently. To do that, you need to install...

9. Overview of web server types
There are several roles that a server can occupy. For each one there's a unifying similarity: they've to become on the network and have other computers connect to them. ...