今天做支撑发现,两台双向同步的mysql明明都相互赋了权限,但是有一台同步就是出错,后台日志显现:
Error reading packet from server: Access denied; you need the REPLICATION SLAVE privilege for this operation
无奈之下,在另一台执行如下操作后报错消失:
grant REPLICATION SLAVE on *.* to ‘root' @' %' identified by ‘password';