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?
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