Just ready to do the MySQL read and write separation experiment, unexpectedly suddenly slave host slave_io_running state all become No
, from the morning until the afternoon can not find the reason, suddenly a thought, instead of using the empty password to try, incredibly come in, but I do not know why?
is registered on master:
650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/87/DC/wKioL1fjjxyA0yj5AADA3BQUAJY258.png-wh_500x0-wm_3 -wmp_4-s_544318835.png "title=" My.png "width=" "height=" 231 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:300px; height:231px; "alt=" Wkiol1fjjxya0yj5aada3bquajy258.png-wh_50 "/>
is logged in under slave:
650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/87/E0/wKiom1fjlP_SZRybAABewmQGQxU037.png-wh_500x0-wm_3 -wmp_4-s_3255675299.png "title=" Nn.png "alt=" Wkiom1fjlp_szrybaabewmqgqxu037.png-wh_50 "/>
Workaround:
Attempt to modify the REPL user password failed.
Delete the REPL user and re-create the user. Success!!!
MySQL user has set password, but login can not fill in password