2017-09-27

MySQL - Table is "Read Only" error message


(1) Locate MySQL's data folder path (run this query, MySQL must be up and running).
select @@datadir;

(2) Change permissions so "mysql" can access it:
chown -Rf mysql:mysql /PATH_TO_DATA_FOLDER/data

(3) Restart MySQL.

(4) Re-attempt to make table/record changes.