Using the MySQL Administrator Tool from within NetBeans IDE 6.1 Beta
By radhika on Mar 17, 2008
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.