t1.1_preparing_the_database
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.
t1.1_preparing_the_database.txt · Last modified: 2020/11/11 20:42 by sahl