Give ALL PRIVILEGES on a database to a local user who has to use a password to access the database : Local User « Privilege « MySQL Tutorial






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








27.4.Local User
27.4.1.Give ALL PRIVILEGES on a database to a local user who has to use a password to access the database
27.4.2.To restrict the user to manipulating data (rather than table or database structures)