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
原文：https://www.cnblogs.com/hiit/p/11465470.html