Instructions to create a database and user using SQL commands.
CREATE DATABASE DATABASENAME; USE DATABASENAME;
CREATE USER XXXXX IDENTIFIED BY 'XXXXXXXXXXX'; CREATE USER PLACEHOLDER IDENTIFIED BY 'PLACEHOLDER'; CREATE USER 'PLACEHOLDER'@'localhost' IDENTIFIED BY 'PLACEHOLDER';
GRANT ALL PRIVILEGES ON *.* TO 'PLACEHOLDER'@'localhost'; GRANT ALL privileges ON `XXXXX`.* TO XXXX@localhost IDENTIFIED BY 'XXXXXXXXXXX'; GRANT ALL PRIVILEGES ON *.* TO 'PLACEHOLDER'@'%' WITH GRANT OPTION; GRANT ALL privileges ON PLACEHOLDER.* TO PLACEHOLDER@localhost IDENTIFIED BY 'PLACEHOLDER';
chown apache:apache -R * # Let Apache be owner find . -type d -exec chmod 755 {} \; # Change directory permissions rwxr-xr-x find . -type f -exec chmod 644 {} \; # Change file permissions rw-r--r--
SELECT User, Host, Password FROM mysql.user;