In this tutorial we will try to install MySQL on Windows 2003 Server Standard Edition SP2. The following is a list of machine specifications used in this task are:
1. First of all download MySQL for Windows at MySQL.com. Double click the msi file.
2. The setup wizard welcome page launched. Click Next.
|
3. Select Typical and click Next.
4. The setup wizard is ready to install MySQL. Click Install.
5. MySQL installation is in progress. Wait and relax.
6. Some advertisements. Click Next.
7. Click Next.
8. The setup wizard completed. Select the Configure the MySQL Server now and click Finish. We will do some basic configuration.
9. Click Next.
10.There are two configurations available. In this case we will do the standard configuration. Click Next. Please refer to MySQL Detailed Configuration steps if you need it.
11.In our case, select Standard Configuration. Click Next.
12.So, we will install MySQL as a service with MySQL5 as a service name and include the Bin directory in the Windows path (environment variables) then we can run MySQL command from any relative path later.
13.Select as shown in the following Figures and click Next.
14.Fill in the password for MySQL root user. This is a super user for MySQL and there are many more users with different privileges that you can create later. The password can be changed later. Please remember the password. Click Next.
----------------------------------------------------------------------------------------------------------------------
15.The MySQL instance configuration wizard will start its work. You can change any settings done previously by hitting the Back button, else just click Execute. There are four stages to be completed by the wizard.
16.The configuration process being executed. Any error will be prompted during this stage and for error(s) you will see a red cross instead of blue tick shown below.
17.From the following Figure, our MySQL instance has been successfully configured. The service seems started successfully means that we can start using MySQL database. Click Finish.
18.For MySQL database manipulations and exercises please go to the MySQL SQL DML Exercise Part 1 andMySQL SQL DML Exercise Part 2.