< Install MySQL on Windows 2003 Server | Main | Install MySQL GUI Tools >

 


 

 

 

MySQL Detailed Configuration Setup on Windows Machine

 

 

 

Rather than using MySQL Standard Configuration setup on Windows, this tutorial is a walkthrough steps using the detailed configuration. You must know your needs in setting up MySQL before following the detailed configuration steps.  The following is the Windows machine specifications used in this task are:

1.      This is a continuation from MySQL installation on Windows XP Pro and Windows 2003 Server Standard Edition provided for whom that chooses the Detailed Configuration. Select the Detailed Configuration and click Next.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

2.      Depending on your database needs, choose appropriately. In this case we select Server Machine. Click Next after you finish.

 

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

3.      Any selection is briefly explained. Depend on your database needs, in our case we select Multifunctional Database. Click Next when you finish.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

4.      We can select the drive or partition where we want the InnoDB datafile to be stored. InnoDB is one of the MySQL storage engine. In our case we just leave as is. Click Next when you finish.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

5.      Next, select the approximate number of concurrent connections to our MySQL database server. In our case we set to 500 and it depends on your web services needs. Click Next when you finish.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

6.      Well, this obvious that we must enable the TCP/IP networking and also set MySQL to strict mode. The 3306 is a standard MySQL port. Click Next when you finish.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

7.      The next setting is the character set to be used. We choose Unicode that support multilingual. Click Next when finish.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

8.      The following settings and that follow are similar to the standard configuration.  We select install MySQL as a Windows service.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

9.      Select MYSQL5 as the service name and select to include Bin directory in the Windows environment variables so that we can run MySQL binaries from any relative Windows path. Click Next when you finish.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

10. Fill in a password for MySQL root user. Click Next.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

11. Next, MySQL wizard is ready to execute the script that contains all the configurations that we have selected. You can change the previous settings by hitting the Back button. Click Execute when you finish.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

12. If there are any error(s) you will see a red cross instead of blue ticks as shown below. Click Finish.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

 

13. The MySQL menus added to the Windows Start > All Programs as shown below.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

14. The MySQL service can be seen and managed through Windows Services snap-in.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

15. Now, let test our MySQL server. Launch MySQL Command Line Client, Start > All Programs > MYSQL > MySQL Command Line Client. Type the root password and hit the Enter key.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

16. Try the help.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

17. Try mysqladmin, a client for performing administrative operations.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

18. Creating a database named moodledb example using mysqladmin.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

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

 

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

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

19. Exploring the MySQL files and folders.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

20. Exploring MySQL binaries.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

21. Login into mysql through command line client as root example.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

22. Showing the available databases.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

23. Exit MySQL.

 

step-by-step on installing php on Windows 2003 server and Win Xp Pro detailed configuration screen shots

 

24. More MySQL statements and database manipulation can be found in: MySQL & DML Exercise 1 and MySQL & DML Exercise Part 2.

 

 

 

 

 

 

 

 


 

< Install MySQL on Windows 2003 Server | Main | Install MySQL GUI Tools >