Creating Mysql DB user


CREATE USER 'xxx'@'%' IDENTIFIED BY 'yyy';

GRANT USAGE ON * . * TO 'xxx'@'%' IDENTIFIED BY 'yyy' 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 `xxx` ;

GRANT ALL PRIVILEGES ON `xxx` . * TO 'xxx'@'%';

This entry was posted on Tuesday, July 3rd, 2007 at 2:30 pm and is filed under MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply