mysql5.5配置文件为空

RT，不管内测版还是正式版都是如此。

补充一句，有的vps上的宝塔可以，但是有的没有，不清楚什么情况

/etc里没有 /www里也没有

vi /etc/my.cnf

把以下这串复制进去

1. [client]
   
2. #password        = your_password
   
3. port                = 3306
   
4. socket                = /tmp/mysql.sock
   
5. 
   
6. [mysqld]
   
7. port                = 3306
   
8. socket                = /tmp/mysql.sock
   
9. datadir = /www/server/data
   
10. default_storage_engine = MyISAM
    
11. #skip-external-locking
    
12. #loose-skip-innodb
    
13. key_buffer_size = 8M
    
14. max_allowed_packet = 1M
    
15. table_open_cache = 32
    
16. sort_buffer_size = 256K
    
17. net_buffer_length = 4K
    
18. read_buffer_size = 128K
    
19. read_rnd_buffer_size = 256K
    
20. myisam_sort_buffer_size = 4M
    
21. thread_cache_size = 4
    
22. query_cache_size = 4M
    
23. tmp_table_size = 8M
    
24. sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIO
    
25. 
    
26. #skip-networking
    
27. #skip-name-resolve
    
28. max_connections = 500
    
29. max_connect_errors = 100
    
30. open_files_limit = 65535
    
31. 
    
32. log-bin=mysql-bin
    
33. binlog_format=mixed
    
34. server-id        = 1
    
35. expire_logs_days = 10
    
36. 
    
37. default_storage_engine = InnoDB
    
38. innodb_data_home_dir = /www/server/data
    
39. innodb_data_file_path = ibdata1:10M:autoextend
    
40. innodb_log_group_home_dir = /www/server/data
    
41. innodb_buffer_pool_size = 16M
    
42. innodb_additional_mem_pool_size = 2M
    
43. innodb_log_file_size = 5M
    
44. innodb_log_buffer_size = 8M
    
45. innodb_flush_log_at_trx_commit = 1
    
46. innodb_lock_wait_timeout = 50
    
47. 
    
48. [mysqldump]
    
49. quick
    
50. max_allowed_packet = 16M
    
51. 
    
52. [mysql]
    
53. no-auto-rehash
    
54. 
    
55. [myisamchk]
    
56. key_buffer_size = 20M
    
57. sort_buffer_size = 20M
    
58. read_buffer = 2M
    
59. write_buffer = 2M
    
60. 
    
61. [mysqlhotcopy]
    
62. interactive-timeout
    

复制代码