Using the MySQL Connector/J (JDBC driver)

RapidMiner Server comes bundled with three database drivers:

  • MSSQL
  • Oracle
  • PostgreSQL

If you want to connect to MySQL databases, you need to manually download and configure the MySQL Connector/J.

This article will walk you through how to:

Install the MySQL JDBC Connector/J

Due to a problem with latest MySQL JDBC driver (8.0.11) the hibernate table update will not work with more than one RapidMiner Server schema per database user. If you want to store multiple RapidMiner Server schemas on the same MySQL Server please create a new user per schema.

  1. Download the MySQL Connector/J from the official website. Currently the recommended version is 8.0.11.

  2. The connector itself is a single file named mysql-connector-java-X.X.XX-bin.jar. Extract this file from the downloaded archive to the data/jdbc folder in your RapidMiner Server Installer folder.

  3. In the database configuration step select MySQL as database system and provide the file path of the connector extracted in the second step as Jar file.

  4. Make sure that the JDBC driver class is set to com.mysql.jdbc.Driver.

  5. Complete the installation.