Skip to content

Instantly share code, notes, and snippets.

@bjethwan

bjethwan/gist:14c37493cec4675abc37453facf7c1fe

Created June 2, 2017 06:54
Show Gist options
  • Save bjethwan/14c37493cec4675abc37453facf7c1fe to your computer and use it in GitHub Desktop.
Save bjethwan/14c37493cec4675abc37453facf7c1fe to your computer and use it in GitHub Desktop.
Download ZIP
mysql - user management
Raw
gistfile1.txt
— User Management
mysql> create user ‘bipin'@'localhost' identified by ‘jethwani’;
mysql> grant all on *.* to 'bipin'@'localhost’;
mysql> grant all on *.* to bipin@'%' identified by 'jethwani’;
mysql> FLUSH PRIVILEGES
mysql> select host, user, password from mysql.user;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment