MySQL Bugs: #72769: mysqlrplshow: Cannot connect to the slave server. Unclear connection message.

Bug #72769	mysqlrplshow: Cannot connect to the slave server. Unclear connection message.
Submitted:	28 May 2014 7:31	Modified:	11 Jun 2014 4:24
Reporter:	Shahriyar Rzayev	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Utilities	Severity:	S1 (Critical)
Version:	1.4.3	OS:	Linux (CentOS 6.5)
Assigned to:		CPU Architecture:	Any

Description:
Dear experts, 
While testing mysqlrplshow again encountered unclear connection message as was in:

http://bugs.mysql.com/bug.php?id=72706

on Master MySQL:

mysql> show slave hosts\G
*************************** 1. row ***************************
 Server_id: 2
      Host: 192.168.1.88
      Port: 3306
 Master_id: 1
Slave_UUID: 5a70670a-d99e-11e3-8dea-080027304b04
1 row in set (0,00 sec)

On Slave server:

mysql> select @@report_host;
+---------------+
| @@report_host |
+---------------+
| 192.168.1.88  |
+---------------+
1 row in set (0,00 sec)

mysql> select @@report_port;
+---------------+
| @@report_port |
+---------------+
|          3306 |
+---------------+
1 row in set (0,00 sec)

[root@linuxsrv4 ~]# ifconfig
eth0      Link encap:Ethernet  HWaddr 08:00:27:30:4B:04  
          inet addr:192.168.1.88  Bcast:192.168.1.255  Mask:255.255.255

mysql> show grants for remote2;
+-----------------------------------------------------------------------------------------------------------------+
| Grants for remote2@%                                                                                            |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'remote2'@'%' IDENTIFIED BY PASSWORD '*A2D73F3748C78DE12A161011AADA385D608EF6D4' |
+-----------------------------------------------------------------------------------------------------------------+
1 row in set (0,00 sec)

mysqlrplshow usage:

[root@linuxsrv3 ~]# mysqlrplshow  --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123#' -vvv
# master on localhost: ... connected.
# Finding slaves for master: localhost:3306

WARNING: There are slaves that had connection errors.

# Replication Topology Graph
No slaves found.

Mistype password:

[root@linuxsrv3 ~]# mysqlrplshow  --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123' -vvv
# master on localhost: ... connected.
# Finding slaves for master: localhost:3306
Error connecting to a slave as remote2@192.168.1.88: Cannot connect to the slave server.
Error Access denied for user 'remote2'@'192.168.1.77' (using password: YES)

WARNING: There are slaves that had connection errors.

# Replication Topology Graph
No slaves found.

'remote2'@'192.168.1.77' --> in fact 192.168.1.77 is a master server and i have already provided --master connection setting. So it really unclear what kind of connection it is.

How to repeat:
All necessary steps provided in description.

Suggested fix:
No idea.

Hello Shahriyar,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

Duplicate of BUG#72707.

Also, the error message concerning wrong password is consistent with the mysql client and therefore not a defect.

$ mysql -uroot -pwrong 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Marked as Duplicate of http://bugs.mysql.com/bug.php?id=72707 ?

"mysqlrplsync does not detect stopped slave server " -> it is another topic and not related to this report at all.

Related to exact this report i must say:

As you see i have already provided --master option for master server.
--master=root:12345@localhost
And why it wants(must) to connect to master server again as user remote2?
(192.168.1.77)

As per dev's note: [29 May 20:49] Charles Bell
Duplicate of BUG#72707.

Marking this as duplicate of BUG#72707