Create the MySQL databases

This section explains the procedures used to create the MySQL databases.

The <configureDatabase> Ant task can create the databases for us. We set 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 databases, we can replace the database names, WRKLGHT and WLREPORT, and the password with database names and a 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 WRKLGHT CHARACTER SET utf8 COLLATE utf8_general_ci;
   GRANT ALL PRIVILEGES ON WRKLGHT.* TO 'worklight'@'Worklight-host' IDENTIFIED BY 'password';
   GRANT ALL PRIVILEGES ON WRKLGHT.* TO 'worklight'@'localhost' IDENTIFIED BY 'password';
   FLUSH PRIVILEGES;
   CREATE DATABASE WLREPORT CHARACTER SET utf8 COLLATE utf8_general_ci;
   GRANT ALL PRIVILEGES ON WLREPORT.* TO 'worklight'@'Worklight-host' IDENTIFIED BY 'password';
   GRANT ALL PRIVILEGES ON WLREPORT.* TO 'worklight'@'localhost' IDENTIFIED BY 'password';
   FLUSH PRIVILEGES;

   Where worklight before the @ sign is the user name, password after IDENTIFIED BY is the user password, and Worklight-host is the name of the host on which MPF runs.

Parent topic: Create databases manually