[求助] mysql連接不了了

nanan8

我發(fā)現(xiàn)wos中的mysql總是出錯。這是為什么呢？錯誤代碼提示如下：
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


mysql的日志在哪兒呢

admin

mysql沒啟動?

多看簽名

nanan8

mysql沒啟動?

多看簽名
admin 發(fā)表于 2013-2-17 10:57

   

我安裝這個方法 執(zhí)行 sed -i 's/skip-innodb/#skip-innodb/g' /www/wdlinux/etc/my.cnf 再 service mysqld restart 試試

結(jié)果還是不行，啟動不了mysql。我也是運行了那個mysql優(yōu)化方案就連接不上了，求解決方法。能重裝mysql嗎

linwuliao

1. [client]
   
2. port            = 3306
   
3. socket          = /tmp/mysql.sock
   
4. [mysqld]
   
5. port            = 3306
   
6. socket          = /tmp/mysql.sock
   
7. skip-external-locking
   
8. back_log = 50
   
9. max_connections = 300
   
10. max_connect_errors = 10
    
11. table_open_cache = 1024
    
12. max_allowed_packet = 16M
    
13. binlog_cache_size = 1M
    
14. max_heap_table_size = 64M
    
15. read_buffer_size = 2M
    
16. read_rnd_buffer_size = 8M
    
17. sort_buffer_size = 2M
    
18. join_buffer_size = 2M
    
19. thread_cache_size = 8
    
20. thread_concurrency = 8
    
21. query_cache_size = 64M
    
22. query_cache_limit = 1M
    
23. ft_min_word_len = 4
    
24. default-storage-engine = MYISAM
    
25. thread_stack = 192K
    
26. transaction_isolation = REPEATABLE-READ
    
27. tmp_table_size = 64M
    
28. #log-bin=mysql-bin
    
29. #binlog_format=mixed
    
30. #server-id = 1
    
31. key_buffer_size = 32M
    
32. bulk_insert_buffer_size = 64M
    
33. myisam_sort_buffer_size = 128M
    
34. myisam_max_sort_file_size = 5G
    
35. myisam_repair_threads = 1
    
36. myisam_recover
    
37. innodb_additional_mem_pool_size = 16M
    
38. innodb_buffer_pool_size = 2G
    
39. innodb_data_file_path = ibdata1:10M:autoextend
    
40. innodb_file_io_threads = 4
    
41. innodb_thread_concurrency = 16
    
42. innodb_flush_log_at_trx_commit = 1
    
43. innodb_log_buffer_size = 8M
    
44. innodb_log_file_size = 256M
    
45. innodb_log_files_in_group = 3
    
46. innodb_max_dirty_pages_pct = 90
    
47. innodb_lock_wait_timeout = 120
    
48. [mysqldump]
    
49. quick
    
50. max_allowed_packet = 16M
    
51. [mysql]
    
52. no-auto-rehash
    
53. [myisamchk]
    
54. key_buffer_size = 256M
    
55. sort_buffer_size = 256M
    
56. read_buffer = 8M
    
57. write_buffer = 8M
    
58. [mysqlhotcopy]
    
59. interactive-timeout
    
60. [mysqld_safe]
    
61. open-files-limit = 8192

復(fù)制代碼

用這個配置文件

nanan8

怎么把配置文件替換呢