Privilege MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Privilege
  4. 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';