安裝wdcp時顯示mysql鏈接錯誤,wdcp安裝好后root賬號無法登陸,錯誤提示:mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user 'root'@'localhost' (using password: YES)'

解決辦法:

修改my.cnf文件在[mysqld]下添加skip-grant-tables重啟數(shù)據(jù)庫(sudo service mysqld restart)后修改root密碼

update mysql.user set password=password(‘新密碼’) where user=’root’;

flush privileges;

quit;

退出后把my.cnf修改回來然后進(jìn)行重啟,問題解決.