1.直接赋值Mysql文件到不同服务器给予777玄仙后仍无法写操作提示Table is read only

解决方法
http://www.9enjoy.com/mysql-table-is-read-only/

I just encountered a similar problem on one of my production servers this morning. (I'm still investigating the cause.) After doing a quick bit of Google-searching, this solved my problem:
mysqladmin -u <username> -p flush-tables
By the way: All directories in /var/lib/mysql should have 700

permissions (owned my the mysql user) and everything within those
directories should be 660 (owned by the mysql user and mysql group).

执行：mysqladmin -u <username> -p flush-tables 即可