CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT SELECT,INSERT,UPDATE ON database.tablename TO 'username'@'%';
FLUSH PRIVILEGES;
GRANT all PRIVILEGES ON database.* TO 'username'@'%';
FLUSH PRIVILEGES;
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT SELECT,INSERT,UPDATE ON database.tablename TO 'username'@'%';
FLUSH PRIVILEGES;
GRANT all PRIVILEGES ON database.* TO 'username'@'%';
FLUSH PRIVILEGES;