Cacher is the code snippet organizer for pro developers

DROP DATABASE IF EXISTS `<db name>`;
CREATE DATABASE `<db name>`
    DEFAULT CHARACTER SET utf8
    DEFAULT COLLATE utf8_general_ci;

USE 'mysql';
GRANT ALL PRIVILEGES ON <db name>.* TO '<username>'@'localhost' IDENTIFIED BY '<password>'

WITH GRANT OPTION;
FLUSH PRIVILEGES;