Yes, the file permissions do affect whether the table can be updated.
The files need to be writable (in the filesystem sense) by the user
running mysqld.
By default MySQL creates directories umask 0700 and files 0660 unless
the UMASK env variable is set differently when mysqld is started. If
Robert Reed wrote:
Greetings,
I've recently inherited a FreeBSD server running MySQL
3.23.54. It's good and stable. I have a second
server that runs as a slave to the first. Everything
goes smoothly until I make changes to a certain table
on my master. This will kill the slave with the error
Greetings,
I've recently inherited a FreeBSD server running MySQL
3.23.54. It's good and stable. I have a second
server that runs as a slave to the first. Everything
goes smoothly until I make changes to a certain table
on my master. This will kill the slave with the error
that this table is
