主服务器里添加命令:
mysql>grant replication slave,file on *.* to 'rep19'@'192.168.1.101' identified by '123456';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
主服务器(假设IP:192.168.1.101),在my.ini里
[mysqld]
max_connections=500
skip-name-resolve
port=3306
server-id =1
log-bin=mysql-bin
binlog-do-db=chengren
binlog-ignore-db=mysql PS:这是不需要同步的数据库
binlog-ignore-db=information-schema PS:这是不需要同步的数据库
从服务器,在my.ini里:
[mysqld]
skip-name-resolveport=3306
server-id = 224
binlog-do-db=chengren
binlog-ignore-db=mysql
binlog-ignore-db=information-schema
replicate-do-db=chengren
replicate-ignore-db=mysql
replicate-ignore-db=information-schema
log-slave-updates
slave-skip-errors=all
master-host = 192.168.1.101
master-user =repl9
master-password =123456
master-port = 3306
master-connect-retry=60
/*以上来自网络转帖,下面是个人案例,很简单的*/
主服务器里添加命令:
mysql>grant replication slave,file on *.* to 'rep19'@'192.168.1.102' identified by '1234569';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
主服务器(假设主服务器IP:192.168.1.1.01),在my.ini里
[mysqld]
max_connections=500
skip-name-resolve
port=3306
server-id =1
log-bin=mysql-bin
binlog-do-db=chengren
binlog-ignore-db=mysql
binlog-ignore-db=information-schema
从服务器,在my.ini里:
[mysqld]
skip-name-resolve
max_connections=500
server-id=3
master-host=192.168.1.101
master-user =rep19
master-password =1234569
master-port=3306
master-connect-retry=60
replicate-do-db=chengren
replicate-ignore-db=mysql