xiao90713的博客

mysql主主同步过程中，会有备机出现异常，机器故障，导致同步失败，机器重启之后，查看mysql同步状态报如下错误：got fatal error 1236 from master when reading data from binary log”Client requested master to start replication from impossible position”如下图 ...

由于mysql安装默认只允许本机访问，添加某个IP访问可如下操作，登录mysql数据库执行如下命令: 1、use mysql; 2、GRANT ALL ON . to root@’10.60.160.%’ IDENTIFIED BY ‘密码’; FLUSH PRIVILEGES; 放开所有IP访问： 1、GRANT ALL ON . to root@’%’ IDENTIFIED BY ...