GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50 : Grant « Privilege « MySQL Tutorial






  1. MySQL Tutorial
  2. Privilege
  3. Grant
GRANT SELECT, UPDATE
ON test.*
TO 'user1'@'domain1.com' IDENTIFIED BY 'pw1'
WITH GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50;








27.3.Grant
27.3.1.Granting Privileges on the new database
27.3.2.A user doesn't need a password if connecting from a certain machine
27.3.3.WITH GRANT OPTION condition allows the user to give others privileges to that database
27.3.4.GRANT ALL
27.3.5.Add localhost to mysql table for accessing sample_db
27.3.6.Grant Select and Update privilege to a user
27.3.7.Grant select, update privilege for a remote user
27.3.8.GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50
27.3.9.GRANT SELECT, UPDATE ON databaseName.*