Tutorials & Training from experienced world class trainers
Join 5700+ of your peers
Get enriched. Access 1270+ quality tutorials right away on:
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
RSSWhat keeps you awake at night?
Do let us know.
We will try our best to deliver tutorials that will help you sleep much better.
The tutorials at have been written by by passionate teachers who have been using open source tools and technologies for years.
Real time images of their development screens are generously used throughout each tutorial.
Download the tutorials to your desktop as PDFs for ready reference whenever you need
Give us your comments or feedback on any of our tutorials.
Your comments help us deliver the best possible training modules.
Is there a specific tutorial you want written? Just Ask.
