Skip to content

Instantly share code, notes, and snippets.

@manhlinhng

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

Last active May 1, 2025 17:48
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
@aktaruzzamancse
Copy link

Thanks..it worked

@anggiaintan
Copy link

didn't work.

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