This error you get when you check " show slave status\G;"
Solution as follows:
Do Telnet:
[root@sj ~]# telnet 12.18.46.78 3666
Trying 12.18.46.78...
Connected to 12.18.46.78.
Escape character is '^]'.
uHost '12.18.46.78' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.
Do Flush host:
[root@sj ~]# mysqladmin -uroot -ppassword flush-hosts
Lets check " show slave status\G;" again.
Done.
Solution as follows:
Do Telnet:
[root@sj ~]# telnet 12.18.46.78 3666
Trying 12.18.46.78...
Connected to 12.18.46.78.
Escape character is '^]'.
uHost '12.18.46.78' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.
Do Flush host:
[root@sj ~]# mysqladmin -uroot -ppassword flush-hosts
Lets check " show slave status\G;" again.
Done.
1 comments:
Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
Devops Training in electronic city
Post a Comment