今天遇到一个这样的提示repair数据表的时候出现“mysql中Table is read only”

在mysql中，Select之类的都正常，但在网页程序中提示：Table '3389' is read only

然后我

SQL代码
chmod -R 0777  /var/lib/mysql/taoniu2007/  

给数据库目录的所属用户和组改为mysql，并加上777的权限，还是一样提示。

程序中使用root连接，也是一样的提示。

引用一下

SQL代码
Hi,  
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).  
(This was on a FreeBSD 4.8 server running MySQL Server 3.23.58)  
Hope this helps,  
Seth  
运行flush-tables后，read only问题解决

执行的命令 mysqladmin -u <username> -p flush-tables