Connecting to a MySQL Database

Connections to databases are managed using database drivers, which enable applications written in different programming languages to interact with the database management system. Java CAPS include the MySQL Native (mysql-connector-java-5.1.5-bin.jar), which is a Java implementation of the JDBC API, and communicates directly with the MySQL Driver.

To Connect to a MySQL Database

1. Click Services tab.
2. Expand the Drivers node from the Database Explorer. Right-click the MySQL (Connector/J driver) and select Connect Using.

   The New Database Connection dialog box is displayed.

   
   
3. In the Basic Setting tab, enter the Database's URL in the corresponding text field.

   The URL identifies the type and location of a database server. The format is jdbc:mysql://hostname:port/database_name.

4. Enter User Name and Password.

   ---

   Note - Select the Remember password option. This is optional.

   ---

   
   
5. Click OK to accept the credentials.

   This displays a new Connection node in the Database Explorer under the Databases node.

   
   
6. Click OK to accept the default schema.
7. Right-click the MySQL Database URL in the Services window (Ctrl-5). Click Connect.

   This opens the New Database Connection dialog box.

   
   

   The illustration shows that the Database Connection is enabled.

   
   

   You are now connected to the MySQL RDBMS in the IDE.