To finish the chapter, we will show you how to create a MySQL data connection both in PAC and PUC. Follow these steps to create a new data connection from PAC:
Click on the Administration tab in the left-hand pane.
Click on the Database Connections tab in the center pane. You will see that there is already one connection defined, SampleData. The following screenshot shows the Database Connections tab:
Click the plus (+) button in the title pane to add a new connection.
Fill in the database connection details. The following configurations are taken from my local setup:
Name:
PHIMinimart
Driver Class:
com.mysql.jdbc.Driver
User Name:
root
Password: (none)
URL:
jdbc:mysql://localhost/phi_minimart
If you are familiar with Java programming, this configuration is actually the JDBC connection string.
Click on the Test button. If everything is ok, a successful notification dialog appears.
Click on the OK button to finish the process.
The
PHIMinimart
connection is now available as your...