MySQL - CREATE DATABASE AND USER

By kenneth, Thu, 10/11/2018 - 20:26

-- Create fresh database
CREATE DATABASE drupal7_db;

-- Create a new MySQL user with specific password
CREATE USER drupal7_dbuser@localhost IDENTIFIED BY 'a2NUpXBffCYUHP6a';

-- Give full access to new MySQL user to new database just created
GRANT ALL PRIVILEGES ON drupal7_db.* TO 'drupal7_dbuser'@'localhost';

-- Rebuild privileges to make persistent those changes
FLUSH PRIVILEGES;