在mysql中,Select之类的都正常,但在网页程序中提示:Table 'cdb_posts' is read only
给数据库目录的所属用户和组改为mysql,并加上777的权限,还是一样提示。
程序中使用root连接,也是一样的提示。
想用myisamchk来检查一下,也提示read only。
最终在这里找到了解决方法:http://www.mysqltalk.org/re-the-table-is-read-only-vt154092.html
运行flush-tables后,read only问题解决:)
给数据库目录的所属用户和组改为mysql,并加上777的权限,还是一样提示。
程序中使用root连接,也是一样的提示。
想用myisamchk来检查一下,也提示read only。
最终在这里找到了解决方法:http://www.mysqltalk.org/re-the-table-is-read-only-vt154092.html
引用
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 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).
运行flush-tables后,read only问题解决:)