Frédéric Olivier :: Développeur Web

18 octobre 2011 Aide mémoire : MySQL Create User, Database and grant access

CREATE USER 'wordpress'@'localhost' IDENTIFIED BY '***';

GRANT USAGE ON * . * TO 'wordpress'@'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 `wordpress` ;

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