Access denied for user root'@'localhost
30 Sep 2020Every time apt-get upgrade upgrades my local MySQL instance on my Ubuntu laptop I get the following error:
(1698, "Access denied for user 'root'@'localhost'") The fix each time is the following, so here it is for me next time save me wasting time googling the error every time.
sudo mysql -u root use mysql; update user set plugin='mysql_native_password' where User='root'; flush privileges; And with that all is well again!
Success? 🎉