Hello MySQL GUI Browser Tool

 

This Tutorial will show you how to create and deploy the MySQL GUI Browser Tool application that will allow the user to interface with the MySQL database server.   It  provides a interface where results are easier to see then compared to a command prompt window.

 

Main Learning's

After following this tutorial you will learn how to:

• Download and install MySQL GUI Browser Tool
• Use the MySQL GUI Tool

Versions used:

• OS: Windows XP SP2

• MySQL 5.0.45

 

Pre-requisites:   You musts have installed MySQL Server before using the MySQL GUI Browser  Browser Tool.  For the MySQL GUI Browser Tool to be running the MySQL Server must be running.  See MySQL wiki

 

 

Tutorial Steps:

1.  Go to the MySQL download web site: http://dev.mysql.com/downloads/gui-tools/5.0.html and select the Windows (x86) package for download.  Click on mirror, and on the next window you can click on "No thanks just take me to downloads!"  You will then see a listing of countries.  Choose a site you want to download from.   

 

2. Download your package

 e.g.  mysql-gui-tools-5.0-r12-win32.msi

 

 

3. Launch mysql-gui-tools-5.0-r12-win32.msi or the latest install file

 

 

4.  Click next when you see the window below.  After a windows with the License Agreement is shown.  If accepted, you will be prompted for the install directory path.  Hit next if you want.

 

 

 

 

5.   On the screen below, leave as Complete and click Next.  Then on the next screen hit the Install button.  The tools will be installed.

 

 

 

6.  You will see the screen below of the install was completed successfully.    Click on Finish

 

 

 

 

 

7.   Start your MySQL Server.  Go to Start -> All Programs ->  MySQL  -> MySQL Server  5.0 ->  MySQL Command Line  Client

 

8.   Type in the password when the window is brought up.  The password is the same password used when you installed MySQL Server.  Please refer to MySQL wiki for more information.

 

9.   Start the MySQL Query Browser.   Go to Start -> All Programs ->  MySQL  -> MySQL Query Browser

 

10.  You will be promted for a user id and password.   Enter in root and the same password you used to start the mySQL Server. 

 

 

11.  If you see the following screen below, hit Ignore

 

 

 

12.   You will then enter in the  mySQL Browser and you can click on the databases towards the right side.  For example in the window below you can click on the database student, then click on table student.

 

 

 

13.  You can use the command window at the top to run queries.   Double click on the student table (square blue icon) See the window below where there is a select * FROM student;