Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Creating a new user with the mysql client and set some privileges for all the tables of a database.
CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'cleartext-password';
GRANT SELECT,INSERT,UPDATE,DELETE ON `database`.* TO 'someuser'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment