Last_Error: Error executing row event: 'Cannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT.'

解決：

vim /etc/my.cnf

# 將此處改為MIXED
# binlog_format=STATEMENT
binlog_format=MIXED

重啟

# 重啟mysql服務(wù)
systemctl restart mysql

主從connecting

              Slave_IO_State: Connecting to master
                  Master_Host: 180.76.123.1
                  Master_User: root
                  Master_Port: 6336
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000111
          Read_Master_Log_Pos: 445057
               Relay_Log_File: instance-6l3gplmb-relay-bin.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File: mysql-bin.000111
             Slave_IO_Running: Connecting
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:

解決辦法

檢查ip、端口、密碼及授權(quán)用戶是否正確。