MySQL 复制 CHANGE MASTER TO

mysql> CHANGE MASTER TO

           ->     MASTER_HOST='master_host_name',

            ->     MASTER_USER='replication_user_name',

            ->     MASTER_PASSWORD='replication_password',

            ->     MASTER_LOG_FILE='recorded_log_file_name',

            ->     MASTER_LOG_POS=recorded_log_position;

GRANT REPLICATION SLAVE ON *.* TO 'rep'@'192.168.%'  IDENTIFIED BY '123456';