表是“只读的" [英] Table is 'read only'

问题描述

当我要在表上执行update查询时，出现错误消息:

When I want to execute an update query on my table I got an error saying:

1036-表data是只读的.

我该如何解决?

/var/db/mysql中的表属性设置为777.

修复表"功能似乎无济于事.

'Repair Table' function doesnt seems to help.

我能做些什么吗?

推荐答案

谁拥有/var/db/mysql并且属于哪个组，应该为mysql:mysql.您还需要重新启动mysql才能使更改生效

who owns /var/db/mysql and what group are they in, should be mysql:mysql. you'll also need to restart mysql for changes to take affect

还要检查当前登录的用户是否具有GRANT访问权限来更新

also check that the currently logged in user had GRANT access to update

这篇关于表是“只读的"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！