wiki.vps-server.ru

# На мастере меняем пароль пользователю
ALTER USER 'repl'@'91.194.2.2' IDENTIFIED BY 'Passw0rd';
FLUSH PRIVILEGES;

# Или добавляем пользователя

GRANT REPLICATION SLAVE ON *.* TO 'repl'@'91.194.2.2' IDENTIFIED BY 'Passw0rd';
FLUSH PRIVILEGES;

# Смотрим состояние мастера
mysql> show master status;
+------------------+----------+--------------+------------------+-----------------------------------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set                             |
+------------------+----------+--------------+------------------+-----------------------------------------------+
| mysql-bin.000006 |  1540536 |              |                  | 1b81016e-7a4d-11ea-9347-fa163e39dbb5:1-312618 |
+------------------+----------+--------------+------------------+-----------------------------------------------+
1 row in set (0.00 sec)


# На SLAVE
CHANGE MASTER TO MASTER_HOST='MASTER_IP', MASTER_USER='repl', MASTER_PASSWORD='Passw0rd', MASTER_LOG_FILE = 'mysql-bin.000006', MASTER_LOG_POS = 1540536;

START SLAVE;