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

[9 Jun 2005 20:01] Jonathan Miller
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'
[14 Jun 2005 8:19] Mats Kindahl
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