Found option without preceding group in config file /etc/mysql/my.cnf

配置读写分离的时候改动my.cnf后报错

Found option without preceding group in config file /etc/mysql/my.cnf
Fatal error in defaults handling. Program aborted!

因为文件默认是就两行数据,按照网上的教程添加三行数据,但是启动不了了
先看一下配置文件的完整版

# /etc/mysql/my.cnf
 
[client]
port = 3306
sockeT = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 128M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 8M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
max_connections = 300
wait_timeout = 30
interactive_timeout = 30
max_connect_errors = 9
long_query_time = 1
tmp_table_size = 16M
# 我直接加入了下面三行 而没有带入[mysqld]这个组  所以报错
#log-bin=master-binlog
#binlog_format=mixed
#server-id = 1
[mysqldump]
quick
max_allowed_packet = 8M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 12M
sort_buffer_size = 1M
read_buffer = 1M
write_buffer = 1M
[mysqlhotcopy]
interactive-timeout
posted @ 2019-07-31 23:07  慢慢行  阅读(286)  评论(0编辑  收藏  举报