Cyclone Cyclone - 1 month ago 13
MySQL Question

Table is 'read only'

When I want to execute an

update
query on my table I got an error saying:


1036 - Table
data
is read only.


How can I fix that?

Table attributes in
/var/db/mysql
are set to
777
.

'Repair Table' function doesnt seems to help.

Is there anything I can do with that?

Answer

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

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

Comments