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. Open the Preferences dialog box (Options > Preferences) and go to Data Sources.
  2. Click the New button in the Data Sources panel.

    The dialog box for configuring a data source is opened.

    Figure: Data Source Drivers Configuration Dialog Box

  3. Enter a unique name for the data source.
  4. Select Generic JDBC in the driver Type drop-down list.
  5. Add the MySQL driver files using the Add Files button.
    The driver file for the MySQL server is called mysql-com.jar. The Driver files section lists download links for database drivers that are necessary for accessing MySQL databases in Oxygen XML Editor.
  6. Select the most appropriate Driver class.
  7. Click the OK button to finish the data source configuration.
  8. Continue on to configure your MySQL connection.