Skip to content

Instantly share code, notes, and snippets.

@ahmed-abdelazim

ahmed-abdelazim/allow.sql

Last active May 29, 2021 17:00
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 ahmed-abdelazim/f1febc6b21d592092edf2b5d4ae028f4 to your computer and use it in GitHub Desktop.
Save ahmed-abdelazim/f1febc6b21d592092edf2b5d4ae028f4 to your computer and use it in GitHub Desktop.
Download ZIP
mysql allow root password login
Raw
allow.sql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'the-password';
SELECT user,authentication_string,plugin,host FROM mysql.user;
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment