my.cny中加入sql_mode=NO_ENGINE_SUBSTITUTION;

my.cny外减进sql_mode=NO_ENGINE_SUBSTITUTION;后呈现ERROR! The server quit without updating PID file怎样处置惩罚

[client]
#password        = your_password
port                = 三三0六
socket                = /tmp/mysql.sock

[mysqld]
port                = 三三0六
socket                = /tmp/mysql.sock
datadir = /data/mysql
default_storage_engine = MyISAM
#skip-innodb
skip-external-locking
key_buffer_size = 三二M
max_allowed_packet = 一M
table_open_cache = 一二八
sort_buffer_size = 七六八K
net_buffer_length = 八K
read_buffer_size = 七六八K
read_rnd_buffer_size = 五一二K
myisam_sort_buffer_size = 八M
thread_cache_size = 一六
query_cache_size = 一六M
tmp_table_size = 三二M

#skip-networking
max_connections = 五00
max_connect_errors = 一00
open_files_limit = 六五五三五

#log-bin=mysql-bin
binlog_format=mixed
server-id        = 一
expire_logs_days = 一0

#innodb_file_per_table = 一
#innodb_data_home_dir = /data/mysql
#innodb_data_file_path = ibdata一:一0M:autoextend
#innodb_log_group_home_dir = /data/mysql
#innodb_buffer_pool_size = 一六M
#innodb_additional_mem_pool_size = 二M
#innodb_log_file_size = 五M
#innodb_log_buffer_size = 八M
#innodb_flush_log_at_trx_co妹妹it = 一
#innodb_lock_wait_timeout = 五0

[mysqldump]
quick
max_allowed_packet = 一六M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 三二M
sort_buffer_size = 七六八K
read_buffer = 二M
write_buffer = 二M

[mysqlhotcopy]
interactive-timeout

《河源网友》:您有没有是写php代码或者sql语句减啥分号
mysql报错失收mysql过错日记,日记里确定有亮确的注明

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注