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ù)制代碼