MYSQL- 数据库登不上 报错：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N......

报错:

• 数据库登不上 报错：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)...

或者

• mysql ERROR 1045 (28000): Access denied for user 'root1'@'localhost' (using..

#1.停止mysql数据库

/etc/init .d /mysqld stop

#2.执行如下命令

mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

#3.使用root登录mysql数据库

mysql -u root mysql

#4.更新root密码

mysql> UPDATE user SET Password=PASSWORD( 'newpassword' ) where USER= 'root' ;

#最新版MySQL请采用如下SQL：

mysql> UPDATE user SET authen