About     Blog     Github

MySQL Cheatsheet

Creating a user

CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';

Grant permissions on a db to a user

GRANT ALL ON mydb.* TO 'jeffrey'@'localhost';