Set up the MySQL databases manually

We can set up the database manually, instead of using the Ant tasks.

Complete the following procedure to set up the MySQL databases.

1. Create the database schema.

   1. Run a MySQL command line client with the option -u root.

   2. Enter the following commands:

      CREATE DATABASE WRKLGHT CHARACTER SET utf8 COLLATE utf8_general_ci;
      GRANT ALL PRIVILEGES ON WRKLGHT.* TO 'worklight'@'Worklight-host' IDENTIFIED BY 'worklight';
      GRANT ALL PRIVILEGES ON WRKLGHT.* TO 'worklight'@'localhost' IDENTIFIED BY 'worklight';
      FLUSH PRIVILEGES;
      CREATE DATABASE WLREPORT CHARACTER SET utf8 COLLATE utf8_general_ci;
      GRANT ALL PRIVILEGES ON WLREPORT.* TO 'worklight'@'Worklight-host' IDENTIFIED BY 'worklight';
      GRANT ALL PRIVILEGES ON WLREPORT.* TO 'worklight'@'localhost' IDENTIFIED BY 'worklight';
      FLUSH PRIVILEGES;
      USE WRKLGHT;
      SOURCE MF_HOME/WorklightServer/databases/create-worklight-mysql.sql;
      USE WLREPORT;
      SOURCE MF_HOME/WorklightServer/databases/create-worklightreports-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 MPF runs.

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

   For more information about max_allowed_packet, see the MySQL documentation, section Packet Too Large.

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

Parent topic: Configure the MySQL databases manually