Mega Code Archive

 

Categories / MySQL / User Permission

 

Specifying Resource Limits

GRANT ALL ON test.* TO 'quinn'@'localhost' IDENTIFIED BY 'SomePass' WITH MAX_CONNECTIONS_PER_HOUR 10 MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 20;