Skip to content

Instantly share code, notes, and snippets.

@jayluxferro

jayluxferro/Mysql_Admin_User.md

Created May 18, 2018 11:26
Show Gist options
  • Save jayluxferro/6f7aa5b0ed2eb067ab1e8623f20881fb to your computer and use it in GitHub Desktop.
Save jayluxferro/6f7aa5b0ed2eb067ab1e8623f20881fb to your computer and use it in GitHub Desktop.
Download ZIP
Mysql Admin User
Raw
Mysql_Admin_User.md
  1. create user and password
mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
  1. Grant privilege to all dbs
mysql> 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