Skip to content

Instantly share code, notes, and snippets.

@mdestafadilah

mdestafadilah/USER MYSQL

Created January 10, 2023 04:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdestafadilah/6e863b1d5c1eaea48280b1150122e65d to your computer and use it in GitHub Desktop.
Save mdestafadilah/6e863b1d5c1eaea48280b1150122e65d to your computer and use it in GitHub Desktop.
Download ZIP
USER MYSQL
Raw
USER MYSQL
```
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
```
SOURCE:https://stackoverflow.com/a/18821224
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment