Create the MySQL database for Application Center

During the MobileFirst installation, the installer can create the Application Center databasebase for you.

The installer can create the for us. Enter the name and password of the superuser account. See Secure the Initial MySQL Accounts on your MySQL database server. Your database administrator can also create the databases for us. When we manually create the database, we can replace the database name (here APPCNTR) and password with a database name and password of our choice. Note that MySQL database names are case-sensitive on Unix.

1. Start the MySQL command-line tool.

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 'password';
   GRANT ALL PRIVILEGES ON APPCNTR.* TO 'worklight'@'localhost' IDENTIFIED BY 'password';
   FLUSH PRIVILEGES;

   Here, we need to replace Worklight-host with the name of the host on which MPF runs.

Parent topic: Create databases manually