mysql报错：The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

解决办法：

 
    
 
     
               
          
         
           1 
          
 
         
          
         
           mysql 
          > 
          SET global read_only 
          = 
          0; 
         
        
             
 
    
 
    
（关掉新主库的只读属性）
 
    
 
    
 
     
               
          
         
           1 
          
2 
          
3 
          
 
         
          
         
           mysql 
          > 
          FLUSH privileges; 
          
mysql 
          > 
          SET global read_only 
          = 
          1; 
          (读写属性 
          ) 
          
mysql 
          > 
          FLUSH privileges; 
         
        
             
 
    
 
    
Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
 
    
 
    
 
     
               
          
         
           1 
          
2 
          
 
         
          
         
           mysql 
          > 
          SET 
          SESSION binlog_format 
          = 
          'ROW'; 
          
mysql 
          > 
          SET GLOBAL binlog_format 
          = 
          'ROW';