1.直接赋值Mysql文件到不同服务器给予777玄仙后仍无法写操作提示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 即可

声明:Asteroid B612|版权所有,违者必究|如未注明,均为原创|本网站采用BY-NC-SA协议进行授权

转载:转载请注明原文链接 - PHP等错误记录与解决办法