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