Accessing the MySQL database from NetBeans

To access the MySQL database from NetBeans, click on the Services tab in the NetBeans left sidebar and expand the Databases section:

Figure A-26. Locating the MySQL database in NetBeans

Then, right-click the MySQL Server icon and select Connect:

Figure A-27. Connecting to the MySQL database

When asked about editing your MySQL Server connection properties, click Yes.

Use your MySQL username and password to connect to the database. Then, expand the MySQL Server node to see the accessible schema, as shown in Figure A-28:

Figure A-28. Connecting to schema1

Then, right-click on schema1 and then on Connect in the pop-up panel.

Next, expand the node whose icon shows a solid (not broken) connection, as shown in Figure A-29:

Figure A-29. The expanded connection node in NetBeans

This shows the details of the Friends table that you created and loaded in MySQL Workbench.

Right-click again on the jdbc:mysql node and select Execute Command…, as shown in Figure A...