User Guide > Tasks > Connecting to Databases > Creating a MYSQL Driver Definition

Creating a MYSQL Driver Definition

This procedure describes how to create a driver definition for your database. A driver definition maps to the location of your driver files.

 

You must have access to MySQL driver files before attempting to create a driver definition.

 

 

Instructions on how to complete a procedure

To create a driver definition for MySQL:

  1. Open the Driver Definitions Preferences page by going  to Window | Preferences | Connectivity | Driver Definitions.

  2. A list of driver definitions will appear in the preferences page.

  3. Scroll down to the MySQL category and select the required MySQL driver.

Driver Definitions Preferences

  1. Click Add.
    The New Driver Definition wizard opens.

New Driver Definition dialog

  1. Expand the nodes until you see the MySQL JDBC Driver.

  2. Select the driver.
    The default driver name will be entered in the Driver Name field. If required, delete this name and enter a new name.

  3. Ensure that the "Edit New Driver Definition Immediately" checkbox is marked.

  4. Click OK.
    The Driver Details wizard opens.

Edit Driver Definition dialog

  1. Delete the sample .jar driver file by selecting it and clicking Remove Jar/Zip.

  2. Click Add Jar/Zip.

  3. Browse your file system to find your MySQL driver and press OK.
    Your driver will be added to the list.

  4. Click OK.

Your new driver definition will be added to your Driver Definitions list. This will allow you to access the driver when connecting to a MySQL database.

Driver Definitions preferences - with new driver

 

Read Also

  Using the Data Tools Platform with MySQL    
  Creating a MySQL Connection Profile    
  Connecting to a MySQL Database    
  Creating and Executing an SQL Query    
  Viewing and Editing Table Content