在Ubuntu下MySQL连接提示Access denied for user 'root'@'localhost'

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

原文链接

$ mysql -u root -p
Enter password: 
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

add skip-grant-tables

service mysql restart

mysql -u root -p

use mysql;
update user set authentication_string=password("你的密码") where user="root";
flush privileges;

quit;