Skip to content

Instantly share code, notes, and snippets.

@blasterpal

blasterpal/mysql_grant.sql

Created September 5, 2012 17:49
Show Gist options
  • Save blasterpal/3641121 to your computer and use it in GitHub Desktop.
Save blasterpal/3641121 to your computer and use it in GitHub Desktop.
Download ZIP
Create mysql user with specific permissions
Raw
mysql_grant.sql
CREATE USER 'joe'@'%' IDENTIFIED BY 'xxxxxx';
# ALL PRIVILEGES is everything except grant
GRANT ALL PRIVILEGES ON APP_production_temp.* TO 'joe'@'%';
GRANT SELECT ON APP_production.* TO 'joe'@'%';
GRANT SELECT ON stats_production.* TO 'joe'@'%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment