Skip to content

Instantly share code, notes, and snippets.

@prawin

prawin/gist:8488791

Created January 18, 2014 10:43
Show Gist options
  • Save prawin/8488791 to your computer and use it in GitHub Desktop.
Save prawin/8488791 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Privileges
Raw
gistfile1.txt
GRANT ALL PRIVILEGES ON test_database.* TO 'user_name'@'%' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON test_database.* TO 'user_name'@'ip' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON test_database.* TO 'user_name'@'domain' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment