主頁(yè) > 知識(shí)庫(kù) > mysql server is running with the --skip-grant-tables option

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

熱門標(biāo)簽:上海智能外呼系統(tǒng)代理商 成都優(yōu)派外呼系統(tǒng) 扎樣申請(qǐng)400電話 沈陽(yáng)電銷外呼系統(tǒng)原理是什么 ps制作地圖標(biāo)注gif 聊城智能外呼系統(tǒng)運(yùn)營(yíng)商 寧波企業(yè)外呼系統(tǒng)收費(fèi) 電子地圖標(biāo)注電話 地圖標(biāo)注人員兼職

The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
意思貌似MYSQL還運(yùn)行在 --skip-grant-tables模式,如何讓他回到原來(lái)的模式

第一種方法:原來(lái)在mysql.ini文件中配置了skip-grant-tables,前面加個(gè)#注釋掉就可以了

修改mysql的配置文件,把skip-grant-tables去掉后,重啟mysql

第二種:

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

解決辦法:

mysql> set global read_only=0;
(關(guān)掉新主庫(kù)的只讀屬性)

flush privileges;

set global read_only=1;(讀寫屬性)

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';

解釋:

set global read_only=0; 關(guān)閉只讀,可以讀寫
set global read_only=1; 開始只讀模式

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; 關(guān)閉只讀,可以讀寫 set global read_only=1; 開始只讀模式

您可能感興趣的文章:
  • The MySQL server is running with the --read-only option so it cannot execute this statement
  • mysql數(shù)據(jù)庫(kù)mysql: [ERROR] unknown option ''--skip-grant-tables''
  • mysql視圖之確保視圖的一致性(with check option)操作詳解
  • MySQL存儲(chǔ)表情時(shí)報(bào)錯(cuò):java.sql.SQLException: Incorrect string value:‘\xF0\x9F\x92\xA9\x0D\x0A...’的解決方法
  • Mysql中的NULL和Empty String
  • javascript連接mysql與php通過(guò)odbc連接任意數(shù)據(jù)庫(kù)的實(shí)例
  • ubuntu下apt-get安裝和徹底卸載mysql詳解
  • MySQL利用AES_ENCRYPT()與AES_DECRYPT()加解密的正確方法示例
  • 利用pt-heartbeat監(jiān)控MySQL的復(fù)制延遲詳解
  • MySQL pt-slave-restart工具的使用簡(jiǎn)介

標(biāo)簽:AXB 三明 汕頭 咸寧 內(nèi)江 宿州 林芝 朔州

巨人網(wǎng)絡(luò)通訊聲明:本文標(biāo)題《mysql server is running with the --skip-grant-tables option》,本文關(guān)鍵詞  mysql,server,running,with,the,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題,煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們,我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無(wú)關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《mysql server is running with the --skip-grant-tables option》相關(guān)的同類信息!
  • 本頁(yè)收集關(guān)于mysql server is running with the --skip-grant-tables option的相關(guān)信息資訊供網(wǎng)民參考!
  • 推薦文章