在實際操作中你是否遇到過這樣的提示,repair數據表中出現“MySQL數據庫中Table is read only”的字樣,那麼對其到底如何解決呢?以下的文章就是針對MySQL數據庫中出現Table is read only的解決方案的描述。
在MySQL中,Select之類的都正常,但在網頁程序中提示:Table '********' is read only
SQL代碼
- chmod -R 0777 /var/lib/MySQL/taoniu2007/
給數據庫目錄的所屬用戶和組改為MySQL,並加上777的權限,還是一樣提示。
程序中使用root連接,也是一樣的提示。
想用myisamchk來檢查一下,也提示read only。
最終在這裡找到了解決方法:http://www.MySQLtalk.org/re-the-table-is-read-only-vt154092.html
引用一下
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問題解決
以上的相關內容就是對MySQL數據庫中Table is read only的解決的介紹,望你能有所收獲。