特牛网址导航

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

网友收藏
  • 链接地址:https://laidefa.blog.csdn.net/article/details/76374085
  • 链接标题:【mysql 错误】1209 - The MySQL server is running with the --read-only option so it cannot execute this s_select @@read_only;-CSDN博客
  • 所属网站:laidefa.blog.csdn.net
  • 被收藏次数:1067
文章浏览阅读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;