8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 1/12

Setup Guide for MySQL 

 For Complete Setup, We require 3 basic components:-

 

1. Mysql Server ( v4.1) :- download “mysql-4.1.22-win32.zip” fromhttp://dev.mysql.com/downloads/mysql/4.1.html . Make sure that you have

downloaded “Windows ZIP/Setup.EXE (x86)” version. 

2. MySql Connector :- download Mysql connector for Java(mysql-connector-java-

5.1.8.zip) from http://dev.mysql.com/downloads/connector/j/5.0.html . Extract this

zip into your “JDK/JRE/LIB/EXT/” for ex:- “C:\Program

Files\Java\jdk1.6.0_06\jre\lib\ext ” . 

3. MySQL GUI tools :- download MySql Gui tools(windows-x86 ver) from

http://dev.mysql.com/downloads/gui-tools/5.0.html . 

 

Now We will start with Instructions to Install Mysql Server :- 

1. Extract the “Setup.exe” file from “mysql-4.1.22-win32.zip” folder. Execute theSetup.exe file.

2. Now follow the Sequence as the pictures below describing: 

  Click on Next Button

 

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 2/12

  

Select “typical” and click on next button. 

 

  

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 3/12

Click on Install Button.

  

 

 

  

Select “Skip Sign-Up” and click on Next button  

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 4/12

  Click On finish Button

 

Now we will configure the MySQL 

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 5/12

  

Select “Standard Configuration” and click on Next. 

 

  

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 6/12

Check both the text checkboxes and then click on Next.

 

  

Provide the password for Root user. Here I have given password as “root”. Now click onNext.

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 7/12

  

To finish this configuration procedure click on Execute. 

 

It was all about Installing and configuring MySql Server.

 

  

 

Installing Mysql Connector for Java 

Now, For Installing Connector . you just have to extract the zip into your

“JDK/JRE/LIB/EXT/” for ex:- “C:\Program Files\Java\jdk1.6.0_06\jre\lib\ext” .  

NOTE: The JDK directory should be the same directory which is used in Eclipse while

making and new project (typically, value of JAVA_HOME Environment variable)

  

Installing Mysql GUI Tool

 Now , To Install MySql GUI Tool follow the underwritten instructions in the for of images :

1. Execute the “.msi” file. Following screen will appear in front of you. Click On

Next button

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 8/12

 

  

2. check the “I accept” check box and then click Next. 

 

 

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 9/12

3. Click On Next button.

  

  

4. Select “Complete” and click on Next. 

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 10/12

  5. Click on Install button

 6.  click Next

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 11/12

  

7. Click on Finish button to finish the installation and configuration process

 

  

8/8/2019 MySql Setup

http://slidepdf.com/reader/full/mysql-setup 12/12

8. Now Start the “Query Browser” Application by clicking on the “Start Menu” and

then “Query Browser” (Its Icon would be created somewhere above “All

Programs”. 

9. Now you have to fill Server Host as “localhost”, Username as “root” andPassword as “root”(It was set to “root” when we configured MySql server). Leave

the Port to default address that is “3306”. Click on OK.  

  

 

 

 So this was all about Installing, configuring and starting the MySql GUI tool. For further

information about “how to use MySql GUI tool” visithttp://downloads.mysql.com/docs/guibook-en.a4.pdf