MySQL database and user requirements

Review the database requirement for MySQL. Follow the steps to create user, database, and configure your database to meet the specific requirement.

About this task

Make sure that you set the character set to UTF8.

The following properties must be assigned with appropriate values:

max_allowed_packet with 256 M or more
innodb_log_file_size with 250 M or more

For more information about how to set the properties, see MySQL documentation.

The procedure creates a database (MFPDATA) and a user (mfpuser) that can connect to the database with all privileges from a host (mfp-host).

Procedure

Run a MySQL command line client with the option -u root.
Enter the following commands:
```
CREATE DATABASE MFPDATA CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON MFPDATA.* TO 'mfpuser'@'mfp-host' IDENTIFIED BY 'mfpuser-password';
GRANT ALL PRIVILEGES ON MFPDATA.* TO 'mfpuser'@'localhost' IDENTIFIED BY 'mfpuser-password';
FLUSH PRIVILEGES;
```
Where mfpuser before the "at" sign (@) is the user name, mfpuser-password after IDENTIFIED BY is its password, and mfp-host is the name of the host on which IBM MobileFirst™ Platform Foundation runs.

The user must be able to connect to the MySQL server from the hosts that run the Java™ application server with the MobileFirst Server applications installed.