Published on

Create MySQL user and grant permissions

All Permissions

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

Read-only Permissions

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, SHOW VIEW ON *.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

Reference