mysql - Table is 'read only'

Question

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 1

In my case, mysql config file had innodb_force_recovery = 1. Commenting that out solved the issue. Hope it helps someone.