Rather than using MySQL Standard Configuration setup on Windows, this tutorial is a walk-through 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:
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. This is a continuation fromMySQL installation on Windows XP Pro andWindows 2003 Server Standard Edition provided for whom that chooses the Detailed Configuration. Select the Detailed Configuration and click Next.
2. Depending on your database needs, choose appropriately. In this case we select Server Machine. Click Next after you finish.
3. Any selection is briefly explained. Depend on your database needs, in our case we select Multifunctional Database. Click Next when you finish.
|
4. We can select the drive or partition where we want the InnoDB datafile to be stored. InnoDB is one of the MySQLstorage engine. In our case we just leave as is. Click Next when you finish.
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.
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.
7. The next setting is the character set to be used. We choose Unicode that support multilingual. Click Next when finish.
8. The following settings and that follow are similar to the standard configuration. We select install MySQL as a Windows service.
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.
10.Fill in a password for MySQL root user. Click Next.
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.
12.If there are any error(s) you will see a red cross instead of blue ticks as shown below. Click Finish.
13.The MySQL menus added to the Windows Start > All Programs as shown below.
14.The MySQL service can be seen and managed through Windows Services snap-in.
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.
16.Try the help.
17.Trymysqladmin, a client for performing administrative operations.
18.Creating a database named moodledb example using mysqladmin.
----------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------
19.Exploring the MySQL files and folders.
20.Exploring MySQL binaries.
21.Login into mysql through command line client as root example.
22.Showing the available databases.
23.Exit MySQL.
24.More MySQL statements and database manipulation can be found in: MySQL & DML Exercise 1 and MySQL & DML Exercise Part 2.