daniekpo
5/17/2019 - 5:24 PM

MySQL - Add User and Grant Permissions

CREATE USER 'dev'@'localhost' IDENTIFIED BY 'devPassword';
GRANT ALL PRIVILEGES ON * . * TO 'dev'@'localhost';
FLUSH PRIVILEGES;

# Other privileges include CREATE, DROP, DELETE, INSERT, SELECT, UPDATE, GRANT-OPTION