my.cny中加入sql_mode=NO_ENGINE_SUBSTITUTION;

一人天

my.cny中加入sql_mode=NO_ENGINE_SUBSTITUTION;后出现ERROR! The server quit without updating PID file如何处理

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 = /data/mysql
   
10. default_storage_engine = MyISAM
    
11. #skip-innodb
    
12. skip-external-locking
    
13. key_buffer_size = 32M
    
14. max_allowed_packet = 1M
    
15. table_open_cache = 128
    
16. sort_buffer_size = 768K
    
17. net_buffer_length = 8K
    
18. read_buffer_size = 768K
    
19. read_rnd_buffer_size = 512K
    
20. myisam_sort_buffer_size = 8M
    
21. thread_cache_size = 16
    
22. query_cache_size = 16M
    
23. tmp_table_size = 32M
    
24. 
    
25. #skip-networking
    
26. max_connections = 500
    
27. max_connect_errors = 100
    
28. open_files_limit = 65535
    
29. 
    
30. #log-bin=mysql-bin
    
31. binlog_format=mixed
    
32. server-id        = 1
    
33. expire_logs_days = 10
    
34. 
    
35. #innodb_file_per_table = 1
    
36. #innodb_data_home_dir = /data/mysql
    
37. #innodb_data_file_path = ibdata1:10M:autoextend
    
38. #innodb_log_group_home_dir = /data/mysql
    
39. #innodb_buffer_pool_size = 16M
    
40. #innodb_additional_mem_pool_size = 2M
    
41. #innodb_log_file_size = 5M
    
42. #innodb_log_buffer_size = 8M
    
43. #innodb_flush_log_at_trx_commit = 1
    
44. #innodb_lock_wait_timeout = 50
    
45. 
    
46. [mysqldump]
    
47. quick
    
48. max_allowed_packet = 16M
    
49. 
    
50. [mysql]
    
51. no-auto-rehash
    
52. 
    
53. [myisamchk]
    
54. key_buffer_size = 32M
    
55. sort_buffer_size = 768K
    
56. read_buffer = 2M
    
57. write_buffer = 2M
    
58. 
    
59. [mysqlhotcopy]
    
60. interactive-timeout
    
61. 
    

复制代码

licess

你有不是写php代码或sql语句加啥分号
mysql报错得发mysql错误日志，日志里肯定有明确的说明