mysql table is read only mode error
1I recently restored a mysql database from a backup and come to find it wouldn’t allow any modifications. The problem was the database belonged to user “root”, which is what I used with SSH to restore the database. The user needs to be mysql.
The fix
Open an SSH connection and navigate to /var/lib/mysql/ and run the following command to recursively set all database owners to mysql -
chown -R mysql:mysql *
Hi I'm Nick Bartlett and thanks for visiting my blog. I'm not much of a writer; many of my posts are short and to the point while others are meant to be a reference for myself and other web developers.
Thanks for that, saved me a headache. For future dummkopfs like me remember to restart mySQL.