Revision as of 08:24, 17 November 2009 by imported>Hundfred (Created page with ' == a) give ALL_PRIVILEGES and the GRANT-right for the user == <pre> grant all ON * . * TO 'ADMIN'@'192.168.10.27' with grant option; </pre> == b) give SUPER-USER rights fo…')
a) give ALL_PRIVILEGES and the GRANT-right for the user[edit]
grant all ON * . * TO 'ADMIN'@'192.168.10.27' with grant option;
b) give SUPER-USER rights for a user (useful for replication)[edit]
grant super ON * . * TO 'ADMIN'@'192.168.10.27';