Mega Code Archive

 

Categories / MySQL Tutorial / Privilege

 

To restrict the user to manipulating data (rather than table or database structures)

GRANT SELECT,INSERT,UPDATE,DELETE ON myDatabase.* TO newuser@localhost IDENTIFIED BY 'newpassword';