MySQL Tutorial/Privilege/Local User

Give ALL PRIVILEGES on a database to a local user who has to use a password to access the database

   <source lang="sql">

GRANT ALL PRIVILEGES ON myDatabase.* TO newuser@localhost IDENTIFIED BY "newpassword";</source>

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

   <source lang="sql">

GRANT SELECT,INSERT,UPDATE,DELETE ON myDatabase.* TO newuser@localhost IDENTIFIED BY "newpassword";</source>