Create the MySQL database for MobileFirst Server administration

During the MobileFirst installation, the installation tools can create the administration database for you.

The installation tools 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 creating the database manually, we can replace the database name (here WLADMIN) and password with a database name and password of the choice.

Attention: On UNIX, MySQL database names are case-sensitive.

1. Start the MySQL command-line tool.

2. Enter the following commands:

   CREATE DATABASE WLADMIN CHARACTER SET utf8 COLLATE utf8_general_ci;
   GRANT ALL PRIVILEGES ON WLADMIN.* TO 'worklight'@'Worklight-host' IDENTIFIED BY 'password';
   GRANT ALL PRIVILEGES ON WLADMIN.* 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 administration database (Optional)