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...