mysql server is running with the --skip-grant-tables option

The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
It seems that MYSQL is still running in --skip-grant-tables mode. How can I get it back to the original mode?

The first method: Skip-grant-tables is configured in the mysql.ini file. Just add a # in front of it and comment it out.

Modify the mysql configuration file, remove skip-grant-tables , and restart mysql

Second type:

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

Solution:

mysql> set global read_only=0;
(Turn off the read-only attribute of the new master database)

flush privileges;

set global read_only=1; (read-write attribute)

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.

mysql> SET SESSION binlog_format = 'ROW';
mysql> SET GLOBAL binlog_format = 'ROW';

explain:

set global read_only=0; turn off read-only, can read and write
set global read_only=1; start read-only mode

mysql> set global read_only=0; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> show variables like '%read_only%'; 
+------------------+-------+ 
| Variable_name | Value | 
+------------------+-------+ 
| innodb_read_only | OFF | 
| read_only | OFF | 
| tx_read_only | OFF | 
+------------------+-------+ 
3 rows in set (0.00 sec) 
 
mysql> set global read_only=1; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> show variables like '%read_only%'; 
+------------------+-------+ 
| Variable_name | Value | 
+------------------+-------+ 
| innodb_read_only | OFF | 
| read_only | ON | 
| tx_read_only | OFF | 
+------------------+-------+ 
3 rows in set (0.00 sec)

set global read_only=0; turn off read-only, can read and write set global read_only=1; start read-only mode