表为“只读"

2022-01-17 00:00:00 sql-update freebsd mysql

当我想在我的表上执行 update 查询时，我收到一条错误消息:

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

1036 - 表 data 是只读的.

1036 - Table data is read only.

我该如何解决这个问题?

How can I fix that?

/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

相关文章