[SOLVED] Table is 'read only'

Issue

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?

Solution

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

Answered By – ncremins

Answer Checked By – Jay B. (BugsFixing Admin)

Leave a Reply

Your email address will not be published.