Step 2 Create an access account on the master machine for the slave machine and grant access to the bin log. 1.Create an account to copy data from the master mysql> CREATE USER 'copy'@'%' IDENTIFIED WITH mysql native password BY '123456'; mysql> GRANT REPLICATION SLAVE ON ** TO 'copy'@'%'; rename C:\ProgramData\MySQLWYSQL Server 8.0\Datalauto.cn then restart mysal 2.Log in to the connection account from the slave Change master to master host='10.7.45.93', master.user='repp, master password=-123456', master log file='mysql-bin.000029', master log pos=695; Step 3 Connect to the primary server from slave computer by the created account on the server. 1. show slave statusG; 2.start slave; Step 4: Verify replication between master and slave computers. 1. Create tables in the master, insert data, and query from the salve to see if replication has been synchronized 2. Delete data from master, and query from the salve to see if replication has been synchronized Step 2 Create an access account on the master machine for the slave machine and grant access to the bin log. 1.Create an account to copy data from the master mysql> CREATE USER 'copy'@'%' IDENTIFIED WITH mysql native password BY '123456'; mysql> GRANT REPLICATION SLAVE ON ** TO 'copy'@'%'; rename C:\ProgramData\MySQLWYSQL Server 8.0\Datalauto.cn then restart mysal 2.Log in to the connection account from the slave Change master to master host='10.7.45.93', master.user='repp, master password=-123456', master log file='mysql-bin.000029', master log pos=695; Step 3 Connect to the primary server from slave computer by the created account on the server. 1. show slave statusG; 2.start slave; Step 4: Verify replication between master and slave computers. 1. Create tables in the master, insert data, and query from the salve to see if replication has been synchronized 2. Delete data from master, and query from the salve to see if replication has been synchronized