Open source training & tutorials from experienced, passionate people
By A Web Design
To download MySQL refer to Lesson 2 - MySQL Download.
Run the setup file of the MySQL Server 5.1 from the sub-directory where it has been saved. When the start screen appears, click Next as shown in Diagram 1.
Diagram 1
Select the Setup Type as Typical and Click Next as shown in Diagram 2.
Diagram 2
The screen displayed will show the path to where MySQL is being installed as shown in Diagram 3.
Diagram 3
Click Install and the install process will commence as shown in Diagram 4..
Diagram 4
The following two screens will be displayed which are of little significance in the installation process.
When they are displayed simply click Next as shown in Diagram 5 and Diagram 6.
Diagram 5
Diagram 6
The installation of MySQL enterprise server is complete as shown in Diagram 7.
Diagram 7
Diagram 8
MySql Server Instance Configuration. Select Standard Configuration as shown in Diagram 9.
Diagram 9
Install MySQL as a Windows service and give it a name. MySQL is the default as shown in Diagram 10.
Diagram 10
Now Configure the MySQL Server instance with your choice of root password as shown in Diagram 11
Enter New Root Password : ????????? (your choice)
Enter Confirm : ???????? (your choice)
Check the check-box of Enable root access from remote machines.
Check the check-box of Create Anonymous Account.
Diagram 11
After entering the confirm password box, the Next button is enabled.
Click on the Next button to automatic configuration process will commence and completed as shown in Diagram 12.
Diagram 12
When MySQL has been installed and configured
At the desktop Click > Start > Run and in the run text-box enter the command cmd
This opens a Command Window with a Command Prompt visible
At the Command Prompt enter the following mysql –u root –p{use any password here greater than 8 characters}
Do not forget the single space between -u and root
The Command Prompt immediately changes to mysql
This indicats that that MySQL, character based client, has loaded into memory and is awaiting your command as shown in Diagram 13
Diagram 13
Please wait...