Create Mysql user, password and grant rights on database

newUserAndDatabase.sql

/** GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’ IDENTIFIED BY 'some_pass' WITH GRANT OPTION; **/
GRANT ALL PRIVILEGES ON DATABASE.* TO 'newuser'@'localhost' IDENTIFIED BY 'some_pass';
FLUSH PRIVILEGES;
/** BACKUP USER **/
GRANT SELECT,LOCK TABLES ON *.* TO 'backup'@'localhost' IDENTIFIED BY 'PASS';