MySQL Workbench IDE Download and Installation Process

Downloading Process :
 
Step 1 : Copy and paste this link http://dev.mysql.com/downloads/workbench/5.1.html in the Browser
window.
Then we can observe at the bottom of the web page with Download buttons. Click the download button
related to windows operating system as shown in the fig below.

Step 2 : After clicking download button the following screen will appear.

 

Click at the “>>No thanks,just take me to the downloads!”the screen related to this is shown below.

Step 3 : Then the following screen will appear for choosing mirror site for faster downloading.

 

We can select one country in this list, for example I select HTTP of The UK Mirror service. see below fig.

Step 4 : Then select Save File radio button and then click OK button.

 

Step 5 : After downloading that zip file, save it in your local system folders.

Step 6 : Right click on that zip file and select extract Here

Step 7 : Finally we obtained mysql-workbench-gpl-5.2.31a-win32 installer software.

 

Installation Process :

Step 8 : Double click on that installer software. then we get the screen as below,

 

Step 9 : Click on Run Button (see in the above screen)

 

Step 10 : click Next button.

Step 11 : click Next button.

Step 12 : Click on Install button. And then Finally click finish button.

It now finishes the installation.

MySQL Database Download And Installation Process

Downloading Process:
Step1 : Click on the link below to access the download page.
           http://dev.mysql.com/downloads/mysql/5.1.html
Step 2 : Select the appropriate Operating System from the drop down menu and click the download button.

 

Step 3 : It pops up a Login Screen. If you already have a MySQL.com account you can login with that,else
create New Account. You can even have the option to download without Login. Click the link 'No thanks,just take me to the downloads!'.

Step 4 : Now choose a mirror site close to you from the list of servers appear on the screen.

 

Step 5 : A dialogue box pop up on the screen. Click Save File Button. It downloads                                  'mysql-essentials- 5.1.55-win32.msi' file.

 

Installation Process :

Start installation process by double click installer file.
Welcome to the setup wizard for MySQL Server 5.1
                   Click Next.

Choose Setup Type
MySQL installer provide 3 type of setup :
        1. Typical; recommend for general use.
        2. Complete; all program features will be installed.
        3. Custom; I prefer this one because I want to specify installation folder
Choose Custom and Click Next.

 

Change install location to C:\mysql\ by click Change button and enter new path. Click Next when you’re ready.

 

Ready to install program

Examine current setting produced by wizard. click Install to start the process.

 

Little advertisement from MySQL click Next.

   Click Next.

 

Click Finish to exit the wizard.
make sure to check “configure the MySQL server now“.

 

Configure MySQL server on Windows 7

MySQL Server Instance Configuration Wizard will start, it will help us to configure MySQL server in easy way.
Click Next.

 

Select “Detailed Configuration” and click Next.

 

Choose “Developer Machine” for server type. It will use minimal amount of memory.

Click Next.

 

Select “Multifunctional Database” for database usage.
Click Next.

 

Click Next.

At this stage MySQL Server successfully installed with account root enabled with password.