mysql链接失败(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES))
修改:
1 #1.停止mysql数据库 2 /etc/init.d/mysqld stop 3 #2.执行如下命令 4 mysqld_safe --user=mysql --skip-grant-tables --skip-networking & 5 #3.使用root登录mysql数据库 6 mysql -u root mysql 7 #4.更新root密码 8 mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root'; 9 #5.刷新权限 10 mysql> FLUSH PRIVILEGES; 11 #6.退出mysql 12 mysql> quit 13 #7.重启mysql 14 /etc/init.d/mysqld restart 15 #8.使用root用户重新登录mysql 16 mysql -uroot -p 17 Enter password: <输入新设的密码newpassword>