Skip to content

Instantly share code, notes, and snippets.

@manhlinhng

manhlinhng/SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'.md

Last active April 21, 2024 05:03
Show Gist options
  • Save manhlinhng/b43d05612c1a901d04566c1fbe1f292c to your computer and use it in GitHub Desktop.
Save manhlinhng/b43d05612c1a901d04566c1fbe1f292c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'.md 
sudo mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;
service mysql restart
@vuducduong
Copy link

thank bro

@Siddharthmak23
Copy link

Thanks..it worked

@RaihanIIUC
Copy link

brother its life saving, works for me too.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment