[实践OK]The MySQL server is running with the --read-only option so it cannot execute
The MySQL server is running with the --read-only option so it cannot execute
解决办法:
mysql> set global read_only=0;
(关掉新主库的只读属性)
flush privileges;
set global read_only=1;(读写属相)
flush privileges;
出现:
The MySQL server is running with the --read-only option so it cannot execute
来自:http://www.cnblogs.com/xionghui/archive/2013/03/01/2939342.html
解决办法:
mysql> set global read_only=0;
(关掉新主库的只读属性)
flush privileges;
set global read_only=1;(读写属相)
flush privileges;
出现:
The MySQL server is running with the --read-only option so it cannot execute
来自:http://www.cnblogs.com/xionghui/archive/2013/03/01/2939342.html
作者:jackxiang@向东博客 专注WEB应用 构架之美 --- 构架之美,在于尽态极妍 | 应用之美,在于药到病除
地址:http://jackxiang.com/post/9484/
版权所有。转载时必须以链接形式注明作者和原始出处及本声明!
评论列表