Mysql主从配置文件,主文件my.cnf,从文件my.cnf完整版。部分配置如下:
[client]
port = 3306
socket =/tmp/mysql.sock
[mysql]
no-auto-rehash
prompt="\u@\h [\d]>"
#pager="less -i -n -S"
#tee=/opt/mysql/query.log
[mysqld]
user = mysql
basedir = /usr/local/mysql
datadir = /data/mysql/mysql3306/data
port = 3306
socket = /tmp/mysql.sock
skip_name_resolve = 1
lower_case_table_names=1
log_bin_trust_function_creators=1