datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock replicate-do-db=shopping binlog-do-db=shopping #复制的库 server-id = 3 #skip-grant-tables = 1 symbolic-links=0 replicate-do-db=shop #需要复制的库 binlog-do-db=shop tmpdir = /tmp #这个最好给个目录 否则会报错 ，今天遇到了 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid max_connections = 1000 binlog-ignore-db=mysql binlog-ignore-db=test binlog-ignore-db=information_schema binlog-ignore-db=performance_schema #不复制的库
replicate-ignore-db=test replicate-ignore-db=mysql replicate-ignore-db=information_schema replicate-ignore-db=performance_schema#不复制的库
validate_password=off #禁用密码策略，否则会很麻烦
