Win7 MySQL master-slave configuration (same machine)

1. Master host add Slave User:

Execute Grant replication Slave,reload,super on * * to [e-mail protected] ' 127.0.0.1 ' identified by ' 123456 '

Note: This command creates a new user account backup, password 123456, and directly assigns permissions;

2. Modify Master's My.ini and restart:

Add under [mysqld]

server-id=10
Log-bin=d:\mysql-5.5\log\log-bin.log

3. Modify the slave My.ini and restart:

Add under [MySQL]

Server-id=20

Log-bin=mysql=bin

Relay-log=relay-bin

Relay-log-index=relay-bin-index

4. Execute in Slave:

Stop slave;

Change Master to master_host= ' 127.0.0.1 ', master_user= ' backup ', master_password= ' 123456 ';

Start slave;

5. Execute show slave status\g; View link status

Win7 MySQL master-slave configuration (same machine)