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

Last active May 1, 2025 17:48

Star (16) You must be signed in to star a gist
Fork (6) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/manhlinhng/b43d05612c1a901d04566c1fbe1f292c.js"></script>
Save manhlinhng/b43d05612c1a901d04566c1fbe1f292c to your computer and use it in GitHub Desktop.

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