MySQL is an Oracle Corporation product, was previously a Sun Microsystems one, and a MySQL Abs one before that. It is one of the most famous open-source relational database management systems, RDBMS, in the world. The code is available under the GNU license.
It is used by many companies, such as Nokia, Facebook, and Google, for its robustness and for being free for use.
At some point, Sun distributed installation packages of NetBeans bundled with MySQL, which is not the case anymore, but MySQL is still integrated and easily configured from it.
For this recipe we will use MySQL version 5.4.1 and MySQL GUI Tools.
Installation and configuration of MySQL Server and components onto the Operating System is beyond the scope of this recipe. What will be learned here is how to configure MySQL with NetBeans so that the integration between database and IDE can be achieved.
In this recipe, we assume that the Database is installed locally and the password is chosen by the user.
Note
For more information and downloads, visit the following link for the database:
http://www.mysql.com/downloads/mysql/
And for workbench visit http://www.mysql.com/downloads/workbench/.
With the IDE open:
- Navigate to the Services window and expand the Databases section.
- Right-click on Databases and select Register MySQL Server....
A MySQL Server Properties window is shown.
- Under Basic Properties, the IDE, by default, enters localhost as Server Host Name and 3306 as Server Port Number.
- Then just add the Administrator User Name and Administrator Password that you configured during MySQL installation.
The MySQL Server Properties window should look more or less like this:
Then click on the Admin Properties tab. Under Path/URL to admin tool, enter the folder for the Administration tool and also the paths to start and stop commands for MySQL under shell or command prompt.
Then click OK.
An example of configured Admin Properties:
A MySQL node is added to the Database section of the Services window.
The Basic Properties tab is the minimum information required to a connect to MySQL server this is all that is needed for the connection to work. The information required to better control the MySQL Server is on the Admin Properties tab. The Start and Stop commands and path for MySQL-related tools are also included in the submenu, which can be accessed by right-clicking.
Upon registration, there are two ways of checking whether MySQL Server is connected or not:
- If the MySQL Server node can be expanded, it means that it is connected
- The same node shows a
Not Connectedstring
Once the node is expanded, the IDE will show the databases included in your server. Note that the number of databases included might differ from system to system, and if the MySQL Server already contains other databases.
Want to Create Databases and Run the Administration tool from within the IDE? You've come to the right place.
To create databases on a registered MySQL Server instance simply:
- Right-click on the MySQL Server at localhost node and select Create Database....
- A Create MySQL Database window will ask for the New Database Name. Enter
mysqltestand press OK. - The Databases subsection will look like this:
To run the MySQL Administration Tool, it is necessary to configure the IDE with the correct path. If unsure how to do this, refer to the beginning of this recipe, under MySQL Server Properties, in the Admin properties tab.
With the configuration in place:
- Navigate to the Services window and expand the Databases node.
- Then right-click on MySQL Server at localhost.
- Select Run Administration tool.