Ubuntu安装mysql5.7报错ERROR 1698
2018-07-09 本文已影响0人
寒冬夜行人_51a4
报错信息:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
解决方法:
sudo mysql -u root -p
select user, plugin from mysql.user;
update mysql.user set authentication_string=PASSWORD('newPwd'), plugin='mysql_native_password' where user='root';
flush privileges;
exit
重启进入