Registering MySQL Database Server in NetBeans IDE

We will learn how to register MySQL database server in Netbeans IDE.

• NetBeans Version - 6.9
• MySQL Version - MySQL-5.1.48
• Operating System - Windows

The following steps describes the procedure for configuring MySQL in Netbeans

Step 1 - Go to Window , then click Services which will open a Services Tab along with the Project Explorer on the left side of the IDE.

Step 2 -Right Click on the Databases and select Register MYSQL Server ... this will open a new popup window

Right Click and Select New Connection

Step 3 - In the new popup window select Basic Properties and provide the following details.

Note - The details may vary based upon the data provided during installation

Step 4 - Now Select Admin Properties and provide the following details and click OK and you are done.

Path/URL to admin tool - {MYSQL_INSTALL_LOCATION}\bin\mysqladmin.exe

Path to start command - {MYSQL_INSTALL_LOCATION}\bin\mysqld.exe 

Arguments -  --defaults-file={LOCATION_OF_my.cnf}  --standalone --console

Path to stop command - {MYSQL_INSTALL_LOCATION}\bin\mysqladmin.exe 

Arguments - --user={USER} -p={PASSWORD}

Step 5 - This will create a new MySql Server instance under Databases as shown below

Step 6 - Validate the MySql Registration by right click on MYSQL Server at XXXXX option as shown above in the image and select Start or Connect. It should successfully start the MySQL server instance if the properties you have set is right.

Please let me know if you face any issues. Your comments and feedbacks are most welcome.