my-master.ini(主) [client] port=3306 default-character-set=utf8
[mysqld] port=3306
character_set_server=utf8
basedir=C:\Program Files\MySQL\mysql-5.6.16-win32
datadir=C:\Program Files\MySQL\mysql-5.6.16-win32\data
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
log-bin=master-bin
log-bin-index=master.bin.index
server-id=1
1.先将my-master.ini放入到mysql安装目录下,将其内容复制到my-default.ini文件中 2.将my-default.ini文件中sql_mode注释掉,进行保存 3.cdm窗口中进入到mysql的安装目录下的bin目录下 4.创建用户 create user jk; 5.添加用户的权限 grant replication slave on . to jk identitified by ‘密码’; 6.mysql –install 服务名称 –defaults-file “配置文件的名称路径” eg:mysql –install MySQL –defaults-file “C:\Program Files\MySQL\mysql-5.6.16-win32\my-default.ini”
my-slave.ini(从) [client] port=3306 default-character-set=utf8
[mysqld] port=3306
character_set_server=utf8
basedir=C:\Program Files\MySQL\mysql-5.6.16-win32
datadir=C:\Program Files\MySQL\mysql-5.6.16-win32\data
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
server-id=2 relay-log=slave-relay-log-bin relay-log-index=slave-relay-log-bin.index
1.数据库从服务器的配置步骤和主服务器配置是一样的 2.change master to master_host=”192.168.1.100” 主服务器地址 master_port=3306, master_user=’jk’, master_password=’123456’; 3.start slave:启动服务器