Mega Code Archive

 

Categories / MySQL Tutorial / Privilege

 

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

GRANT ALL PRIVILEGES ON myDatabase.* TO newuser@localhost IDENTIFIED BY 'newpassword';