Setting up your MySQL database manually for Application Center

You can set up your MySQL database for Application Center manually.

1. Create the database schema.
   1. Run a MySQL command line client with the option -u root.
   2. Enter the following commands:

      CREATE DATABASE APPCNTR CHARACTER SET utf8 COLLATE utf8_general_ci;
      GRANT ALL PRIVILEGES ON APPCNTR.* TO 'worklight'@'Worklight-host'IDENTIFIED BY 'worklight';
      GRANT ALL PRIVILEGES ON APPCNTR.* TO 'worklight'@'localhost' IDENTIFIED BY 'worklight';
      FLUSH PRIVILEGES;
      
      USE APPCNTR;
      SOURCE product_install_dir/ApplicationCenter/databases/create-appcenter-mysql.sql;

      Where worklight before the "at" sign (@) is the user name, worklight after IDENTIFIED BY is its password, and Worklight-host is the name of the host on which IBM MobileFirst™ Platform Foundation runs.

2. Add the following property to your MySQL option file: max_allowed_packet=256M

   For more information about option files, see the MySQL documentation at MySQL.

3. Add the following property to your MySQL option file: innodb_log_file_size = 250M

   For more information about the innodb_log_file_size property, see the MySQL documentation, section innodb_log_file_size.