wiki:technical:vs:mysql_master_slave
Это старая версия документа!
# На мастере меняем пароль пользователю 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
wiki/technical/vs/mysql_master_slave.1657828875.txt.gz · Последнее изменение: 2022/07/14 23:01 — Diman