Mega Code Archive

 

Categories / MySQL / User Permission

 

GRANT statement specifies the MAX_QUERIES_PER_HOUR and MAX_UPDATES_PER_HOUR options, setting the value of each to 50

GRANT SELECT, UPDATE ON test.* TO 'user1'@'domain1.com' IDENTIFIED BY 'pw1' WITH GRANT;