CREATE USER 'rob'@'localhost' IDENTIFIED BY 'somepass';
GRANT ALL PRIVILEGES ON *.* TO 'rob'@'localhost' WITH GRANT OPTION;
CREATE USER 'rob'@'%' IDENTIFIED BY 'somepass';
GRANT ALL PRIVILEGES ON *.* TO 'rob'@'%' WITH GRANT OPTION;
CREATE USER 'admin'@'localhost';
GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
CREATE USER 'dummy'@'localhost';