1. Removing users from the database. DROP USER 'USERNAME'@'HOSTNAME'; 2. Creating users – 3 common ways: A) The default way:
CREATE USER 'USERNAME'@'HOSTNAME' IDENTIFIED BY 'USERPASSWORD'; B) As an insert statements:
INSERT INTO `mysql`.`user` (Host,User,Password) VALUES('localhost','dummy',''); FLUSH PRIVILEGES; #it is neccessary, when creating users this way C) Batch adding users. Create a file (useradd.sql for example) which contains all create users statements :
CREATE USER 'USERNAME'@'HOSTNAME' IDENTIFIED BY 'USERPASSWORD'; GRANT SELECT ON `DATABASE`. ...