99精品国产综合久久久久五月天,免费观看欧美大片毛片不用播放器 ,AV无码理论片在线观看免费网站,国产精品国产成人国产三级

Board logo

標(biāo)題: [求助] mysql連接不了了 [打印本頁]
作者: nanan8    時間: 2013-2-17 00:46     標(biāo)題: mysql連接不了了

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


mysql的日志在哪兒呢
作者: admin    時間: 2013-2-17 10:57

mysql沒啟動?

多看簽名
作者: nanan8    時間: 2013-2-18 17:13

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    時間: 2013-2-18 17:48

  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    時間: 2013-2-19 10:32

怎么把配置文件替換呢



歡迎光臨 WDlinux官方論壇 (http://fudaan.com/bbs/) Powered by Discuz! 7.2