Table of Contents

Preparing the database

Platform4PHP uses the MySQL database. There are two steps for preparing the database. First we need to create the global 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 global database

Then we create the global database.

CREATE DATABASE people_application;

That's it.