[求助] 無法連接mysql，請檢查mysql是否已啟動及用戶密碼是否設(shè)置正確!:

vnlife3

各位大牛好

系統(tǒng)：WDLINUX OS 1.0 32bit
問題發(fā)生原因：

我點擊了MYSQL管理中的MYSQL設(shè)置。將默認(rèn)值更改為分類的“一般”
然后點擊確定。


然后點擊了重啟mysql就提示“無法連接mysql，請檢查mysql是否已啟動及用戶密碼是否設(shè)置正確!:”

我百度了一下運行了tools下的sh腳本，并沒有作用。
重啟mysqld服務(wù)提示：Starting MySQL. ERROR! Manager of pid-file quit without updating file.

還望各位指教 謝謝。 我很喜歡wdlinux也很需要它。

wulali

把/www/wdlinux/etc/my.cnf文件里的設(shè)置還原一下，然后在SSH里執(zhí)行service mysqld restart即可

以下是my.cnf文件的默認(rèn)設(shè)置

1. # mysql conf /etc/my.cnf
   
2. # Created by http://cd-genova.com
   
3. # Last Updated 2010.06.01
   
4. 
   
5. [client]
   
6. port                = 3306
   
7. socket                = /tmp/mysql.sock
   
8. [mysqld]
   
9. port                = 3306
   
10. socket                = /tmp/mysql.sock
    
11. skip-external-locking
    
12. key_buffer_size = 128M
    
13. max_allowed_packet = 1M
    
14. table_open_cache = 256
    
15. sort_buffer_size = 1M
    
16. read_buffer_size = 1M
    
17. read_rnd_buffer_size = 2M
    
18. myisam_sort_buffer_size = 8M
    
19. thread_cache_size = 8
    
20. query_cache_size= 16M
    
21. thread_concurrency = 8
    
22. max_connections = 300
    
23. wait_timeout = 30
    
24. interactive_timeout = 30
    
25. max_connect_errors = 9
    
26. long_query_time = 1
    
27. tmp_table_size = 16M
    
28. #log-bin=mysql-bin
    
29. #binlog_format=mixed
    
30. #server-id        = 1
    
31. [mysqldump]
    
32. quick
    
33. max_allowed_packet = 8M
    
34. [mysql]
    
35. no-auto-rehash
    
36. [myisamchk]
    
37. key_buffer_size = 12M
    
38. sort_buffer_size = 1M
    
39. read_buffer = 1M
    
40. write_buffer = 1M
    
41. [mysqlhotcopy]
    
42. interactive-timeout

復(fù)制代碼

vnlife3

回復(fù) 2# wulali


   error: Found option without preceding group in config file: /etc/my.cnf at line: 1Fatal error in defaults handling. Program aborted
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
ERROR! MySQL manager or server PID file could not be found!
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
Starting MySQL. SUCCESS!
[root@fs1 etc]# service mysqld restart
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
Shutting down MySQL. SUCCESS!
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
Starting MySQL. SUCCESS!

vnlife3

修復(fù)完成了！ 謝謝 wulali 的幫助！

speedking

也碰到這個問題  按照帖子的方法弄好了

hhxxttxs

烏班圖 安裝一鍵 訪問 8080 之后出現(xiàn)   無法連接mysql，請檢查mysql是否已啟動及用戶密碼是否設(shè)置正確!:
按照帖子 還原 重啟，還是顯示 無法連接mysql，請檢查mysql是否已啟動及用戶密碼是否設(shè)置正確!:

chen7413

后臺都進(jìn)不去怎么弄�。。。。�！

qq514408389

用工具sh /www/wdlinux/tools/mysql_wdcp_chg.sh

omaman

這個問題我也遇到了，看了所有的幫助都沒有解決問題。后來我發(fā)現(xiàn)是root密碼當(dāng)初修改的時候我使用了"."，重啟mysql正常，但是就是出現(xiàn)請檢查密碼的錯誤。只要修改root密碼為數(shù)字字母就行了。

板栗籽雞

怎么解決，第一次接觸linux，我也出現(xiàn)了這樣的問題。。。

zhqs425

用工具sh /www/wdlinux/tools/mysql_wdcp_chg.sh

nano

centos 6.5 最小化安裝
用 sh /www/wdlinux/tools/mysql_wdcp_chg.sh 后出現(xiàn)
Running..., Please Wait...
err
求解

nano

#sh /www/wdlinux/tools/mysql_root_chg.sh

Running..., Please Wait...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Change root password is OK
Current root password is:66JswiWp


是不是數(shù)據(jù)庫密碼問題？執(zhí)行這個shell還是不行。

nano

# /etc/rc.d/init.d/mysqld status
ERROR! MySQL is not running, but lock exists

nano

重裝系統(tǒng)試試看行不行，可能是我以前安裝過mariadb沒卸載干凈的原因。