< Install MySQL Using Detailed Configuration | Main | Use MySQL GUI Tool >

 


 

 

Install, Test and Use MySQL 5.0.12 GUI Tools

On Windows XP Pro SP2

 

 

 

The machine specifications used in this task are:

 

  • Intel Pentium Core 2 Duo, 2.2 GHz.

  • Windows XP Pro SP2 + periodical patches + periodical updates.

  • 2 GB DDR2 RAM.

  • 160 GB SATA HDD.

  • 17” SyncMaster 713N monitor.

  • MySQL GUI Tools 5.0 R2

 

Other than using the MySQL Command Line Client tool, there are several similar GUI tools (commercial and opensource). One of the GUI tool is MySQL GUI Tools and in this module we would like to try MySQL Graphic User Interface tools that should be synonym with Windows. Other than doing the MySQL server management, all the MySQL statements can be executed using MySQL Query Browser. Firstly, download the tools at MySQL.com. This MySQL GUI tools include the following items:

 

  1. MySQL Administrator.

  2. MySQL Query Browser.

  3. MySQL Migration Toolkit.

 

1.      Double click the msi file.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

2.      Windows installer splash screen will be launched.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

3.      The setup wizard welcome page is shown below. Click Next.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

4.      Accept the License Agreement and click Next.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

5.      We just accept the given default destination folder. Our MySQL folder is C:\Program Files\MySQL in this case. Change accordingly. Click Next.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

6.      We select a complete setup type. Click Next.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

7.      Click Install if you are ready. If you want to change the previously set settings, just hit the Back button.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

8.      The installation is in progress.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

9.      Some advertisements. Just click Next.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

10. Click Next.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

11. Click Finish.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

12. Menus for MySQL GUI have been added to the Windows start menu.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

13. Let try MySQL Administrator. Click the MySQL Administrator. We are login as root, so enter the root password. If you already have MySQL user other than root then you can use it to login. The 3306 is a standard MySQL port. We use to login to localhost (127.0.0.1) where our MySQL has been installed. If you have MySQL installed on other server, use the server name or IP address. Fill in the required information as shown below and click OK.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

14. The Details is shown in the following Figure. We are not using them.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

15. Let explore what we have in this MySQL GUI. First page is Server Information page. It is just read only information.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

16. The following is the Service Control information page. We can stop and start the MySQL service here.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

17. The Configure Service tab contains more information.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

18. The following is Startup Variables page. Well, so many information. Explore all the tabs and there are many settings that can be set or unset.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

19. The following is User Administration page. We can add new MySQL user here and assign privileges.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

20. The following is schema privileges page. We can see available privileges assigned to the database schema or modify the current privileges.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

21. The following is a resources page.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

22. The following is the Server Connection information page.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

23. The following is MySQL health status page. Browse all the tabs.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

24. The following is MySQL Server logs page.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

25. The following is Replication status page; if there is any replication implemented we can see it here.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

26. The following is the backup information page. We can create a backup and schedule it.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

27. Let try making a backup. Click the New Project button, put a backup project name and select items to be backup. Click Execute Backup Now.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

28. In this case, we put the backup file in dbasebkup folder.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

 

29. The following is a backup message after completing the backup process.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

30. The following is the Restore page.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

31. Just to see the backup file that we have made previously is functioning, click the Open Backup File button. We can restore this backup.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

32. Finally, the Catalogs. Quite many things can be done here. Select one database under the Schemata. In this case we select myhotel database. Click the Details >> button.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

33. We can edit a table in a database by selecting any row and right click mouse or use the buttons available at the bottom. In this case, select Edit Table context menu.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

34. As shown in the following Figure, we can edit table properties. Apply Changes to save any changes that have been made.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

35. Next, click the Create Table button. Create a new table named mynewtable in myhotel database (or any other database available in your localhost). You can follow what have been shown in the following Figure. Click Apply Changes to save any changes that have been made.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

36. Our new table can be seen in the following Figure.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

37. Let verify our previous step using MySQL Client Command Line console, to see the table that we previously created using MySQL management tools.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

38. We can also edit the data table or records as shown in the following Figure.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

39. By choosing Edit Table Data, MySQL Query Browser will be launched as shown in the following Figure. MySQL Query Browser can also be accessed through Windows Start menu.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

40. Fill in the information similar to login to MySQL Administrator previously done. Click OK.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

----------------------------------------------------------------------

 

-------------------------------------------------------------------------

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

41. Select a database to make it a default schema as shown below. Select a database > right click mouse > Make Default Schema.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

42. The selected database will be in bold.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

43. The following steps show how to edit data in a table. Expand the database node > select and hold the table to be edited > then drag to the left window (green SQL commands will be highlighted) > put it onto the SELECT statement (release your mouse onto the SELECT statement).

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

44. The following Figure shows another way on how to automate the SQL script creation.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

45. Then, the SQL SELECT statement can be seen in script window as shown below. Click the Execute button ( ) to execute the script.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

46. The query result will be displayed in Resultset window shown below.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

47. Let edit some data in the table. Select the edit button ( ). Then, click any cell that you want to edit. For example, the G423 and then change it to G200. Press Enter.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

48. The cell will be highlighted as shown below. Next, to save the changes, click the Apply Changes button ( ). Any error(s) will be displayed and the update process was failed else the changes were saved.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

49. The following Figure shows another example, the steps (1 > 2 > 3) to edit table data. We are editing the dateFrom column data.

 

step-by-step on istall, test and use MySQL GUI tool screen snapshots

 

50. To see those changes that have been made, click the Refresh button ( ).

 

At this stage you can create and manipulate a database, populate it with data and manipulating other database objects such as tables and records using MySQL GUI tools. It seems more productive than using the MySQL statements through MySQL Command Line Client console done previously. In the next tutorial we will create and manipulate database using this MySQL GUI tool.

 

 

 

 

 

 

 

 


 

< Install MySQL Using Detailed Configuration | Main | Use MySQL GUI Tool >