Sylvain Deloux web architect

To create a MySQL database with its own user :

CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'user_password';

GRANT USAGE ON *.* TO 'user_name'@'localhost' IDENTIFIED BY 'user_password';

CREATE DATABASE IF NOT EXISTS `database_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

GRANT ALL PRIVILEGES ON `database_name`.* TO 'user_name'@'localhost';