Page Comparison

GRANT ALL PRIVILEGES ON `flexbi_private%`.* TO 'flexbi_private'@'%' IDENTIFIED BY 'secret';

(Replace "secret" with your Replace secret with chosen password). When you have specified will specify the database connection parameters in flex.bi then a flexbi_private database eazyBI then eazybi_private database will be created. Later when additional flex.bi eazyBI accounts will be created then the data from each account data will be stored in separate databases with names flexbieazybi_jira_dwh_N (where  where N is account ID number).

In addition you should

download MySQL JDBC driver and copy

included mysql-connector-java-*.jar to 

eazybi_private/lib directory (MySQL JDBC driver is not included in Private

eazyBI distribution due to GPL license restrictions).

Please also tune

MySQL memory settings to speed up both data import and data queries. The following my.cnf settings are recommended:

innodb_buffer_pool_size = 1024M
innodb_log_file_size = 256M
query_cache_size= 16M
query_cache_type = 1

The parameter innodb_buffer_pool_size will specify how much database data MySQL can store in the memory - adjust it to your available server memory (the more data MySQL will store in the memory the less disk input/output operations will be performed). If you change innodb_log_file_size then it will require that you delete existing MySQL log files before starting the MySQL server.