Why SHOW SLAVE HOSTS Returns the Master’s IP Instead of the Slave’s IP in MySQL Replication

This article explains why MySQL’s show slave hosts command on a master displays the master’s own IP instead of the replica’s, by examining the report_host parameter, deprecated syntax, and configuration copying practices, and provides steps to reproduce and resolve the issue.

Database AdministrationReplicationmysql

0 likes · 7 min read

Why SHOW SLAVE HOSTS Returns the Master’s IP Instead of the Slave’s IP in MySQL Replication