MySQL Bugs: #11219: error connecting to master does not show in "SHOW SLAVE STATUS\G;"

Bug #11219	error connecting to master does not show in "SHOW SLAVE STATUS\G;"
Submitted:	9 Jun 2005 20:01	Modified:	14 Jun 2005 8:19
Reporter:	Jonathan Miller	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S3 (Non-critical)
Version:	5.1.0-wl2325-wl1354-new	OS:	Linux (Linux)
Assigned to:	Mats Kindahl	CPU Architecture:	Any

Description:
Looking at the "SHOW SLAVE STATUS\G;" all looked fine, but I was not getting the updates. I had forgot to grant permissions.

ERROR LOG SHOWED:
050609 21:43:46 [ERROR] Slave I/O thread: error connecting to master 'rep@ndb08:3307': Error: 'Host 'ndb10.mysql.com' is not allowed to connect to this MySQL server'  errno: 1130  retry-time: 1  retries: 86400

How to repeat:
Start replication, but do not grant permissions.

Suggested fix:
When in this situationLast_Errno:  & Last_Error: from show slave status should show the following:

                 Last_Errno: 1130
                 Last_Error: Slave I/O thread: error connecting to master 'rep@ndb08:3307': Error: 'Host 'ndb10.mysql.com' is not allowed to connect to this MySQL server'

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html