MySQL master-slave configuration process

First refer to the MySQL5.5 official manual for the following chapters:

Section 6.4 How to set up replication

13.6.1 section for controlling the primary server SQL statements

13.6.2 section for controlling SQL statements from the server

6.8 section copy startup options

6.5 section replication compatibility between different MySQL versions

Note: The program and the copy SQL statements shown in the following sections require Super permissions

The following begins to set up master-slave replication:

1 Create an account to log into the master server from the service

MySQL > GRANT REPLICATION SLAVE on * * to ' Copy account name ' @ ' Copy account domain ' identified by ' password ';

MySQL master-slave configuration process