Skip to content

Instantly share code, notes, and snippets.

@kiproping

kiproping/server.sh

Created July 30, 2018 20:53
Show Gist options
  • Save kiproping/028b071926fcbb81b2d2ae760c1b1154 to your computer and use it in GitHub Desktop.
Save kiproping/028b071926fcbb81b2d2ae760c1b1154 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
server.sh
#List all users
SELECT User FROM mysql.user;
# Create new user
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
# Graniting priviledges (databs.table)
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment