Mega Code Archive

 

Categories / MySQL Tutorial / Privilege

 

WITH GRANT OPTION condition allows the user to give others privileges to that database

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.