mysqlCreateUserAndDb.sql

CREATE USER 'dbname'@'localhost' IDENTIFIED BY  'passwd';

GRANT USAGE ON * . * TO  'dbname'@'localhost' IDENTIFIED BY  'passwd' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE DATABASE IF NOT EXISTS  `dbname` ;

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