Tech Journal Back to Tech Journal

Creating a new user in MySQL and assigning permissions to it

The MySQL command:

GRANT SELECT, INSERT, UPDATE, DELETE ON monty_db.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass';

Creates the user "monty" that can only connect from "localhost", using password "some_pass". And allows it to select,insert,update,delete from any table from the "monty_db" database.

Back to Tech Journal