Board logo

标题: [求助] mysql连接不了了 [打印本页]
作者: nanan8    时间: 2013-2-17 00:46     标题: mysql连接不了了

我发现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 发表于 2013-2-17 10:57



   
我安装这个方法 执行
sed -i 's/skip-innodb/#skip-innodb/g' /www/wdlinux/etc/my.cnf
再
service mysqld restart
试试


结果还是不行，启动不了mysql。我也是运行了那个mysql优化方案就连接不上了，求解决方法。能重装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
复制代码
用这个配置文件
作者: nanan8    时间: 2013-2-19 10:32

怎么把配置文件替换呢



欢迎光临 WDlinux官方论坛 (http://wdlinux.cn/bbs/) Powered by Discuz! 7.2