Snippetse to help create/alter(update) a user in MySQL and grant permissions.

create_and_update_user_mysql.sql

-- Create User
CREATE USER 'username'@'%' IDENTIFIED BY 'somepassword';
-- Update User
ALTER USER 'username'@'%' IDENTIFIED BY 'somepassword';
-- Grant to Specific Schema/DB
GRANT ALL ON some-schema.* TO 'username'@'%';
-- Grant user permissions similiar to master user in RDS
GRANT ALL PRIVILEGES ON `%`.* TO 'username'@'%' WITH GRANT OPTION;
GRANT LOAD FROM S3 ON *.* TO 'username'@'%';
GRANT SELECT INTO S3 ON *.* TO 'username'@'%';