MySQL add User (Grant)

mysql_grant

GRANT ALL ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON db_name.* TO 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'127.0.0.%' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT REPLICATION SLAVE ON *.* TO repl@"192.168.1.%" IDENTIFIED BY 'password';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON db_name.* TO 'username'@'%' IDENTIFIED BY 'password';
GRANT SELECT, LOCK TABLES ON *.* TO  ‘backup’@’localhost’
IDENTIFIED BY ‘backup_password’; # mysqldump
GRANT SELECT ON *.* TO  ‘backup’@’localhost’
IDENTIFIED BY ‘backup_password’; # mysqldump
FLUSH PRIVILEGES;