Using the MySQL Administrator Tool from within NetBeans IDE 6.1 Beta

NetBeans6.1 Beta has additional support for MySQL. It is now easier to create, launch, and administer MySQL databases from the DataBase Explorer in the IDE.  Some of the key  features offered are:

  • Automatic and manual registering of MySQL Server.
  • Create & Delete Databases from within the IDE.
  • Launch the MySQL Administrator Tool from within the IDE.

What is very exciting is the ability to bring up the MySQL Administrator Tool.  So, I tried this with NetBeans IDE 6.1 Beta, and it is a breeze. I already had MySQL5.0 all setup from before, so did not have to download that. Also, NetBeans automatically registered  MySQL when I first started the IDE.  The MySQL node will show up under the Databases node in the Services tab if a running MySQL Server is detected on the local machine at the default port. Below is the screen shot showing the MySQL Server node.


I did not have any GUI database administration tool installed , so I downloaded  it from the MySQL GUI Tools Downloads site. I then manually registered the tool in the IDE (Like the database, the IDE will try to auto-detect the admin tool as well. ). To manually register the admin tool, go to the Services tab in the IDE, select the Databases ->  MySQL Server node, and right click. From the drop down menu, select Properties. In the Properties window select the Admin Properties tab. In the "Path/URL to the admin tool"  text box, enter the path to the MySQL admin tool or browse to the admin tool executable file. Below is the screen shot showing this:

To Launch the MySQL Administrator Tool: Go to  the Services tab in the IDE, select Databases ->  MySQL Server node, and right click. From the drop down menu, select and choose Administer. The MySQL Administrator window comes up. Below are  the screen shot of the MySQL Administrator Tool.

Accessing of the admin tool from within the IDE  gives you easy access to all the functionality offered by the tool.  Ofcourse, some of the things you can do from the admin tool, now are also available from the IDE. For example creating databases, executing sql through the Query editor. Below are screen shots of the IDE's Query editor and the MySQL Query Browser. 


Note,  to launch the MySQL Query Browser, from the MySQL Administrator , select  Tools -> MySQL Query Browser.

This gives NetBeans users more tight integration with MySQL database. For more  information on the new database features in NetBeans, visit the NetBeans IDE 6.1 Beta New & Noteworthy page. Also, more information on the MySQL database Tools can be found here.


This is nice. But i want to ask a question for you guy how i can display data of mysql table in jtable.

Posted by Dilip Chaudhary on March 17, 2008 at 04:12 PM PDT #

Check the following:

Posted by Radhika on March 18, 2008 at 05:04 AM PDT #

I would just like to thank Radhika for the tutorial on how to populate a JTable in Netbeans.

It just a fantastic explanation of using a JTable. I can use a JTable via "had coding" but really struggled using a JTable in NB.

You have opened my eyes!

If you have any more tutorials please post them...... your detail is excellent.

Thanks again

Posted by Stephan Jusypiw on March 25, 2008 at 08:47 AM PDT #

very good for developers

Posted by vivek kumar kanaujia on March 25, 2008 at 08:55 PM PDT #

How do i display data of a MySQL table in a table which is placed on a Visual Web JSF page?

Posted by Rohan on May 06, 2008 at 08:17 PM PDT #

The following URL provides a tutorial for using table component in visual web:

Also, the URL provides details on enabling the sample database used in the previous tutorial in mysql.

Posted by Karthik on May 27, 2008 at 01:14 AM PDT #

To bad the MySQL admin tool is not available for Solaris. How can they not have a version for the owners product?

Posted by Thommy M. on June 22, 2008 at 01:14 AM PDT #

From :
There are a number of installations that we recognize (see list below). If any
of these installations are detected on the users's machine, then we will
automatically register the MySQL node and set up the properties for the start,
stop and administration tool commands.

Note that on UNIX installations, if the installation detected is one we know
requires root for start and stop commands, and we detect the UNIX command
'gksu', then we will invoke gksu when running the start and stop commands. This
will bring up a dialog from the operating system prompting the user for the
root password, and then the command is run as root.

List of Recognized Installations
Platform Name Admin command
Solaris/OpenSolaris Webstack Installation <none>
Start Command
/usr/bin/gksu /usr/bin/svcadm enable
Stop Command
/usr/bin/gksu /usr/bin/svcadm disable

Does the above help?

I do see that the issue in issuezilla mentions that the issue has been fixed for windows, mac and linux but does not mention solaris. You may want to reopen the issue and request the status of the bug for solaris.

Posted by Karthik on June 22, 2008 at 04:04 AM PDT #

This is fantastic! I'm running Ubuntu 8, Netbeans 6 and MySQL. Where's the "database" node in services, though? My "services" tab/window is blank.


Posted by Thufir on July 04, 2008 at 04:40 PM PDT #

By default, you should see the following four nodes in Services tab: Databases, Web Services, Enterprise Beans (2.x) and Servers.

It is possible that the userdirectory is corrupted. Can you try running the ide with a fresh userdir, as documented at

Posted by Karthik on July 06, 2008 at 06:20 AM PDT #

meant to say 8.04 here :)

Posted by tim on July 17, 2008 at 04:48 PM PDT #

thank you !

Posted by hamza on July 23, 2008 at 10:40 PM PDT #


I need a help. How can I add some data from an interface which is created by using swing to a MySql table. Please explain or tell any helping URLs. I need very urgent. Thanks in advance.

Posted by Sarumathy on October 06, 2008 at 04:33 AM PDT #

Can you check out
and see if they help?

Posted by Karthikeyan Rajeswaran on October 06, 2008 at 05:49 AM PDT #


I have installed netbeans 6.5, mysql5.1 and mysql admin tools. when i tried to launch admin tools from IDE it's showing an error message as foillows. error process 740. the requested operation requires elevation. and it was due to Help needed plz.

Posted by chandu on December 27, 2008 at 10:05 PM PST #

The error "740 equested operation requires elevation" seems to be a Vista specific message, which relates to the
privileges of the current user.

You may want to check out:

Posted by Karthikeyan Rajeswaran on December 29, 2008 at 04:37 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed

A blog for NetBeans users maintained by NetBeans Support team. For professional support, please check out Support Resources.


« July 2016