Step 2 Create Access Account Master Machine Slave Machine Grant Access Bin Log 1create Acc Q43803141
We were unable to transcribe this imageStep 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:ProgramDataMySQLWYSQL Server 8.0Datalauto.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 Show transcribed image text
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:ProgramDataMySQLWYSQL Server 8.0Datalauto.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
Expert Answer
Answer to Step 2 Create an access account on the master machine for the slave machine and grant access to the bin log. 1.Create an…
OR