Skip to content

Instantly share code, notes, and snippets.

@lao9s

lao9s/Grant all privileges to databases prefix for specific mysql user

Created May 4, 2020 15:10
Show Gist options
  • Save lao9s/5447b4673d14689abf1a868c7480e93f to your computer and use it in GitHub Desktop.
Save lao9s/5447b4673d14689abf1a868c7480e93f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Grant all privileges to databases prefix for specific mysql user
# Need to authorized with root user(sudo su) to mysql -u root
GRANT ALL PRIVILEGES ON `tenant%`.* TO 'test_proagent'@'%' WITH GRANT OPTION;
#witch tenant is prefix of databases and test_proagent is user name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment