Preparing the database

Platform4PHP uses the MySQL database. There are two steps for preparing the database. First we need to create the master database, and if we want to use the full capabilities of Platform4PHP's ability to work with instances, we also need a database user that is allowed to create new databases.

Creating the user

We start by creating a user for Platform4PHP and granting them full permissions.

CREATE USER 'people_database_user'@'localhost' IDENTIFIED BY 'mysecretpassword';
GRANT ALL ON *.* TO 'persons_database_user'@'localhost' WITH GRANT OPTION;

Creating the master database

Then we create the master database.

CREATE DATABASE people_application;

That's it.