Initialize MySQL Pentaho Repository database

To initialize MySQL so that it serves as the Pentaho Repository, you will need to run several SQL scripts to create the Hibernate, Quartz, Jackrabbit (JCR), and Pentaho Operations Mart components.

CAUTION:

Use the ASCII character set when you run these scripts. Do not use UTF-8 because there are text string length limitations that might cause the scripts to fail.

The sections in this article take you through the steps to initialize the MySQL Pentaho Repository database.