Skip to content

Instantly share code, notes, and snippets.

@jfriv

jfriv/MySQL_grants_all_and_select_only

Created March 6, 2018 02:47
Show Gist options
  • Save jfriv/fe5ab870f910c684d7514538be5e69b6 to your computer and use it in GitHub Desktop.
Save jfriv/fe5ab870f910c684d7514538be5e69b6 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Grant Statements - All privileges and select only
Raw
MySQL_grants_all_and_select_only
GRANT ALL PRIVILEGES ON mydatabase.* to 'myuser'@'10.%' IDENTIFIED BY 'mypassword';
GRANT SELECT, CREATE TEMPORARY TABLES, SHOW DATABASES ON *.* TO 'myuser'@'10.%' IDENTIFIED BY 'mypassword';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment