【mysql 错误】1209 - The MySQL server is running with the --read-only option so it cannot execute this s_select @@read_only;-CSDN博客

网站介绍:文章浏览阅读2.4w次,点赞5次,收藏4次。1209 - The MySQL server is running with the–read-only option so it cannot execute this statement一般这个错误有两种原因:1.连到从库了。从库一般设置为只读。2.主库的read_only参数被修改为1为了先解决问题,先去查询主库上read_only参数的值。果然read_only被设置为1.手工修改为0后,_select @@read_only;