mysql输入正确的密码也登陆不了
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES)
# mysql -u root mysql //或者直接 mysql 命令
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES; //记得要这句话,否则如果关闭先前的终端,又会出现原来的错误
mysql> quit
service mysqld restart
搞定
如果不能执行,则执行下面保证有权限执行命令
service mysqld stop
mysqld_safe --skip-grant-table
mysql