< Install MySQL on Windows XP Pro | Main | Install MySQL Using Detailed Configuration >

 


 

 

Install, Test and Use MySQL 5.0.45 on Windows 2003 Server Standard Edition SP2

 

 

 

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:

  • OS: Windows 2003 Server Standard Edition SP2.

  • Memory: 2 GB.

  • HDD: 160 x 2 GB

  • Processor: Intel Xeon 3.66 GHz

  • MySQL 5.0.45

1.      First of all download MySQL for Windows at MySQL.com. Double click the msi file.

 

step-by-step on installing php on Windows 2003 server screen shots

 

2.      The setup wizard welcome page launched. Click Next.

 

step-by-step on installing php on Windows 2003 server screen shots

 

3.      Select Typical and click Next.

 

step-by-step on installing php on Windows 2003 server screen shots

 

4.      The setup wizard is ready to install MySQL. Click Install.

 

step-by-step on installing php on Windows 2003 server screen shots

 

5.      MySQL installation is in progress. Wait and relax.

 

step-by-step on installing php on Windows 2003 server screen shots

 

6.      Some advertisements. Click Next.

 

step-by-step on installing php on Windows 2003 server screen shots

 

7.      Click Next.

 

step-by-step on installing php on Windows 2003 server screen shots

 

8.      The setup wizard completed. Select the Configure the MySQL Server now and click Finish. We will do some basic configuration.

 

step-by-step on installing php on Windows 2003 server screen shots

 

9.      Click Next.

 

step-by-step on installing php on Windows 2003 server screen shots

 

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.

 

step-by-step on installing php on Windows 2003 server screen shots

 

 

11. In our case, select Standard Configuration. Click Next.

 

step-by-step on installing php on Windows 2003 server screen shots

 

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.

 

step-by-step on installing php on Windows 2003 server screen shots

 

13. Select as shown in the following Figures and click Next.

 

step-by-step on installing php on Windows 2003 server screen shots

 

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.

 

 

----------------------------------------------------------------------------------------------------------------------

step-by-step on installing php on Windows 2003 server screen shots

 

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.

 

step-by-step on installing php on Windows 2003 server screen shots

 

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.

 

step-by-step on installing php on Windows 2003 server screen shots

 

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.

 

step-by-step on installing php on Windows 2003 server screen shots

 

18. For MySQL database manipulations and exercises please go to the MySQL SQL DML Exercise Part 1 and MySQL SQL DML Exercise Part 2.

 

 

 

 

 

 

 

 


 

< Install MySQL on Windows XP Pro | Main | Install MySQL Using Detailed Configuration >