MySQL报错:The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement等问题
1.登录的mysql:mysql –u root –p
mysql> set global read_only=0;
(关掉新主库的只读属性)
flush privileges;
2.修改mysql配置文件my.cnf,该文件在/etc目录下
重启mysql服务:service mysqld restart