How to Configure a MySQL Data Source

To connect to a MySQL server, create a data source of a generic JDBC type, based on the MySQL JDBC driver available on the MySQL website. The following steps describe how you can configure such a data source:
  1. Open the Preferences dialog box 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.