mysql -u root -p登录MySQL报错:ERROR 1698 (28000): Access denied for user ‘root’@‘localhost’ 前边加上sudo
1、sudo mysql -u root -p 登录
2、查看MySQL账户
select user, plugin from mysql.user;
3、修改密码,新版MySQL对密码进行了限制
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123');
SHOW VARIABLES LIKE 'validate_password%'; # 查看限制规则