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 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.