Skip to content

Instantly share code, notes, and snippets.

@sharifbdp

sharifbdp/Create new user with rights only for specific DB in Mysql

Created September 9, 2016 21:08
Show Gist options
  • Save sharifbdp/4e2943384d7a1b783a09765ac8ee4153 to your computer and use it in GitHub Desktop.
Save sharifbdp/4e2943384d7a1b783a09765ac8ee4153 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Create new user with rights only for specific DB in Mysql
# Loggin to Mysql
# Set proper value in ( DB_NAME, NEW_DB_USER_NAME, PASSWORD_FOR_NEW_USER )
-> GRANT ALL PRIVILEGES ON DB_NAME.* To 'NEW_DB_USER_NAME'@'localhost' IDENTIFIED BY 'PASSWORD_FOR_NEW_USER';
-> FLUSH PRIVILEGES;
# For Delete User
-> DROP USER ‘demo’@‘localhost’;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment