CREATE USER 'citywear'@'localhost' IDENTIFIED BY '****************'; GRANT USAGE ON * . * TO 'citywear'@'localhost' IDENTIFIED BY '****************' 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 `citywear` ; GRANT ALL PRIVILEGES ON `citywear` . * TO 'citywear'@'localhost';