Cacher is the code snippet organizer for pro developers

CREATE USER 'user'@'%';
SET PASSWORD FOR 'user'@'%' = PASSWORD('password');

GRANT ALL PRIVILEGES ON database.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;