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