Skip to content

Instantly share code, notes, and snippets.

@nghiahsgs
Created September 9, 2020 16:08
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 nghiahsgs/02ae079df921cc1bb2c60a4542e12289 to your computer and use it in GitHub Desktop.
Save nghiahsgs/02ae079df921cc1bb2c60a4542e12289 to your computer and use it in GitHub Desktop.
mysql -u root -p
SELECT user,authentication_string,plugin,host FROM mysql.user;
CREATE USER 'nghiahsgs4'@'%' IDENTIFIED WITH mysql_native_password BY '261997';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'nghiahsgs4'@'%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment