Skip to main content

Preparing to run the MySQL collector

Setting up pre-requisites for running the collector

Make sure that the machine from where you are running the collector meets the following hardware and software requirements.

Table 1.



Hardware (for on-premise runs only)


8 GB


2 Ghz processor

Software (for on-premise runs only)


Click here to get Docker.

JDBC Driver

The computer must have the appropriate JDBC driver on its file system. specific objects (for both cloud and on-premise runs)


You must have a ddw-catalogs (or other) dataset set up to hold your catalog files when you are done running the collector.

If you are using Catalog Toolkit , follow these instructions to prepare the datasets for collectors.

Preparing MySQL

Creating a user in MySQL for running the collector

Run the following SQL statements to set up a new user with appropriate permissions to harvest from MySQL.

  1. Create a new user:

    CREATE USER 'ddw_user'@'%' IDENTIFIED BY '<password>';
  2. Grant the permissions to the user:

    GRANT SELECT, SHOW VIEW, EXECUTE ON *.* TO 'ddw_user'@'%';

Downloading the JDBC driver


This task is only required for on-premise run of collectors.