Mysql登录错误:ERROR 1045

friend-sen

Mysql登录错误

1. # mysql -uroot
2. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
3. 或
4. # mysql -uroot -p
5. Enter password:
6. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

解决：

1. # /etc/init.d/mysql stop
2. # mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
3. # mysql -u root mysql
4. mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
5. mysql> FLUSH PRIVILEGES;
6. mysql> quit
7. 
   
8. # /etc/init.d/mysql restart
9. # mysql -uroot -p
10. Enter password:[输入已修改的密码newpassword]
11. mysql> quit
12. 
    

Mysql修改密码

1. #mysqladmin -uroot -p password 'newpassword'
2. Enter password: