[求助] mysql升級5.5后數(shù)據(jù)庫無法連接phpMyAdmin錯誤2002

crossdasky

登錄phpMyAdmin報錯：

phpMyAdmin - Error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

wordpress報錯：

Error establishing a database connection

按照論壇教程（http://cd-genova.com/bbs/viewthread.php?tid=5461 ）操作的，并且嘗試了老大在http://cd-genova.com/bbs/viewth ... ghlight=mysql%2B5.5 說的修改localhost為127.0.01還是同樣的錯誤。

請問這個是什么情況？謝謝
還有我的 /www/wdlinux/init.d/mysqld 文件是不是有多余的東西，在ssh嘗試用vi修改的時候總是保存不了。http://pan.baidu.com/share/link?shareid=141086264&uk=1671249803
超字數(shù)發(fā)布了，為了能預(yù)覽把后綴改成txt了。

嗨嗨

我的也是這個問題怎么解決？

crossdasky

回復(fù) 5# 向上的蔥子

請問這個要如何設(shè)置？ 謝謝

向上的蔥子

mysql配置文件里面指定user為root

crossdasky

本想著如果用另一臺vps重復(fù)步驟看看哪里出錯了，但現(xiàn)在v3安裝直接是高版本了？

crossdasky

回復(fù) 2# 向上的蔥子

看了下好像mysql運行有問題這個怎么解決？謝謝

1. [root@iZm5eaj9b52jsu50vyaxhmZ ~]# service mysqld start
   
2. env: /etc/init.d/mysqld: No such file or directory
   
3. [root@iZm5eaj9b52jsu50vyaxhmZ ~]# service mysqld startservice mysqld start
   
4. env: /etc/init.d/mysqld: No such file or directory
   
5. [root@iZm5eaj9b52jsu50vyaxhmZ ~]#
   
6. [root@iZm5eaj9b52jsu50vyaxhmZ ~]# service mysqld starts
   
7. env: /etc/init.d/mysqld: No such file or directory
   
8. [root@iZm5eaj9b52jsu50vyaxhmZ ~]# find mysqld
   
9. find: `mysqld': No such file or directory
   
10. [root@iZm5eaj9b52jsu50vyaxhmZ ~]# cd /etc/init.d
    
11. [root@iZm5eaj9b52jsu50vyaxhmZ init.d]# find mysqld
    
12. mysqld
    
13. [root@iZm5eaj9b52jsu50vyaxhmZ init.d]# service mysqld start
    
14. env: /etc/init.d/mysqld: No such file or directory
    
15. [root@iZm5eaj9b52jsu50vyaxhmZ init.d]# mysqladmin restart
    
16. mysqladmin: connect to server at 'localhost' failed
    
17. error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
    
18. Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
    
19. [root@iZm5eaj9b52jsu50vyaxhmZ init.d]# /ect/init.d/mysql restart
    
20. -bash: /ect/init.d/mysql: No such file or directory
    
21. [root@iZm5eaj9b52jsu50vyaxhmZ init.d]# cd
    
22. [root@iZm5eaj9b52jsu50vyaxhmZ ~]#
    
23. [root@iZm5eaj9b52jsu50vyaxhmZ ~]# mysqladmin restart
    
24. mysqladmin: connect to server at 'localhost' failed
    
25. error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
    
26. Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
    
27. [root@iZm5eaj9b52jsu50vyaxhmZ ~]#

復(fù)制代碼

向上的蔥子

看下是否啟用了MySQL的root賬戶，再看下密碼是否正確