Edit online

How to Configure MySQL Data Source Drivers

To connect to a MySQL server, you need to create a generic JDBC type data source based on the MySQL JDBC driver available on the MySQL website.

To configure this data source, follow these steps:

  1. Go to https://www.oxygenxml.com/database_drivers.html and download the appropriate MySQL driver.
  2. Open the Preferences dialog box (Options > Preferences) and go to Data Sources.
  3. Click the New button in the Data Sources panel.

    The dialog box for configuring a data source is opened.

    Figure 1. Data Source Drivers Configuration Dialog Box

  4. Enter a unique name for the data source.
  5. Select Generic JDBC in the driver Type drop-down list.
  6. Click the Add Files button and select the MySQL driver file that you downloaded.
    The driver file for the MySQL server is called mysql-com.jar.
  7. Select the most appropriate Driver class.
  8. Click the OK button to finish the data source configuration.
  9. Continue on to configure your MySQL connection.