Wednesday, January 20, 2010

Create user in mysql

CREATE USER 'remote'@'%' IDENTIFIED BY '******';


GRANT ALL PRIVILEGES ON * . * TO 'remote'@'%' IDENTIFIED BY '******' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;



GRANT ALL PRIVILEGES ON `remote\_%` . * TO 'remote'@'%';

No comments:

Post a Comment