MySQL出錯：ERROR 1045 (28000)的解決方案

標籤：

MySQL突然不能用了，癥狀如下：

[[email protected] ok]# mysqlERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO)
[[email protected] ok]# mysql -uroot -pEnter password: ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)
[[email protected] ok]# /etc/init.d/httpd start正在啟動 httpd：
[[email protected] ok]# /etc/init.d/mysqld restart           停止 mysqld： [確定]正在啟動 mysqld： [確定]
[[email protected] ok]# mysqlERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO)[[email protected] ok]# mysql -uroot -pEnter password: ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)
解決方案：重改密碼[[email protected] ok]# /etc/init.d/mysqld stop停止 mysqld： [確定]
[[email protected] ok]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &[1] 10354[[email protected] ok]# 150404 16:46:14 mysqld_safe Logging to ‘/var/log/mysqld.log‘.150404 16:46:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql[[email protected] ok]# mysql -u root mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -A。。。。。。。Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.mysql>

[[email protected] ok]# mysql -u root -p
Enter password:

mysql>

問題解決。

 

MySQL出錯：ERROR 1045 (28000)的解決方案