WITH GRANT OPTION condition allows the user to give others privileges to that database : Grant « Privilege « MySQL Tutorial






  1. MySQL Tutorial
  2. Privilege
  3. Grant
GRANT ALL PRIVILEGES
ON myDatabase.*
TO newuser@localhost
IDENTIFIED BY 'newpassword'
WITH GRANT OPTION;

This would allow the user 'newuser' to give others privileges to SELECT,INSERT,UPDATE or DELETE.

No user can GRANT more privileges that they themselves possess.









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.*