For up-to-date product documentation, see the IBM MobileFirst Foundation Developer Center.


Set up your MySQL database manually for Application Center

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


Overview

Complete the following procedure to set up your MySQL database.


Procedure

  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 our 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 our 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.

Parent topic: Configuring the MySQL database manually for Application Center