ERROR 1045 (28000): Access denied for user (using password: YES)
解決:
1、先停止mysql服務,指令如下:
#/etc/init.d/mysql stop
2、重新啟動服務,指令如下:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
3、登入mysql并修改密碼:指令和SQL如下:
# mysql -u root mysql
mysql> update user set password=PASSWORD(‘新密碼‘) where user=‘root‘;
mysql> flush privileges;
mysql>commit;
mysql>quit;
# /etc/init.d/mysql stop
# /etc/init.d/mysql start
4、檢視mysql背景程序是否啟動了,指令如下:
#/etc/init.d/mysql status
#mysql -uroot -p
Enter password:<輸入新設定的密碼>
5、檢視資料資訊:
mysql>show databases;
如果報告下面錯誤:
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
請執行下面指令:
mysql>SET PASSWORD=PASSWORD(‘新密碼‘);
再執行:
一切好了ok了!