Table is 'read only'

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

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

(This answer is related to the headline, but not to the original question.)

In case you (like me) are trying to temporarily alter data via the MySQL Workbench interface:

• If the table does not have a primary key, MySQL Workbench has no way of identifying the row you are trying to alter, so therefore you cannot alter it.

• Solution in that case is to either alter the data via another route, or simply to add a primary key to the table.

In any case, I hope it helps someone :)