Connecting NetBeans with MySQL

Click on the Services tab in the NetBeans IDE, and navigate to Databases | Drivers. You will see that NetBeans comes with several different database drivers:

Right-click on the Databases node, and click on Register MySQL Server…as shown in the following screenshot:

For Windows users, this will open a dialog box with default settings. Enter the admin password used when installing MySQL server in the previous chapter, and check the Remember Password option:

Mac users will see a different window prior to setting the connection properties. Select the MySQL driver before clicking on the Next button:

This will then allow you to specify the required database connection details:

When finished with these tasks, you will see MySQL Server listed in the Databases node. Right-click on the server, and select Connect to connect to the server (if not already connected):

This will connect NetBeans to MySQL server and list the available databases. Right-click on the server...