The MySQL server is running with the --read-only option so it cannot execute this statement
是因为有人锁库了，设置为只读模式，所以才会出现上述问题
解决办法：
mysql> set global read_only=0;
（关掉新主库的只读属性）
flush privileges;
mysql>set global read_only=1;
(开启新主库的只读属性)
flush privileges;
相关阅读
相关 The MySQL server is running with the –read-only option so it cannot execute this statement
The MySQL server is running with the –read-only option so it cannot execute this statem
清疚相关 MYSQL导出数据出现The MySQL server is running with the --secure-file-priv option so it cannot execute this
今天尝试使用 into outfile导出数据的时候出现错误： The MySQL server is running with the --secure-file-priv
相关 MySql磁盘占满，阿里云提示“The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute “
今天照常打开日志文件查看日志，结果发现一大堆报错：“The MySQL server is running with the LOCK\_WRITE\_GROWTH optio
深藏阁楼爱情的钟相关 The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
mysql 在执行写入操作的时候,报错: The MySQL server is running with the --skip-grant-tables optio
相关 mysqldump导出数据 The MySQL server is running with the --secure-file-priv option so it cannot execute
Got error: 1290: The MySQL server is running with the --secure-file-priv option so it c
相关 mysql5.7导出数据报错The MySQL server is running with the --secure-file-priv option so it cannot execute
想把user表的数据导出到user.csv，在导出mysql数据到本地时报错，语句如下： mysql> SELECT FROM user INTO OUTFILE
相关 The MySQL server is running with the --secure-file-priv option so it cannot execute 解决放法
当使用mysql select from into outfile 发生错误，The MySQL server is running with the --secure-
相关 Linux：ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cann
实操：阿里云CentOS 7.4 64位服务器 修改mysql数据库配置文件无密码登录后，修改密码报错： ERROR 1290 (HY000): T
相关 The MySQL server is running with the --read-only option so it cannot execute this statement
是因为有人锁库了，设置为只读模式，所以才会出现上述问题 解决办法： mysql> set global read\_only=0; （关掉新主库的只读属性） flu
港控/mmm°相关 问题：The MySQL server is running with the--skip-grant-tables option
问题：The MySQL server is running with the–skip-grant-tables option 安装mysql的时候出现这个问题，在更新用户
还没有评论，来说两句吧...