Hi.
AFAIK, a table is considered read only, if either the underlying
filesystem says so (what you called OS attribute) or it is a
compressed table.
If it would be a problem with the privileges, you would rather get an
error like "Access denied for ... to ...".
So your problem is quite probably
Rick:
I believe this is a faq, but check permissions.
bash-2.05$ ls -lrtd /mysql/
drwxr-x--- 42 mysqlmysql4096 May 1 11:34 /mysql/
[root@winslow RPMS]# ls -lrt /var/lib/mysql/
total 12
drwx--2 mysqlmysql4096 May 24 22:01 test
-rw-rw1 mysqlmysql
Richard,
Friday, May 24, 2002, 5:04:49 PM, you wrote:
RD> I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a
RD> password is required for access.
RD> Both GRANT and REVOKE give errors saying "Table 'User' is read only". A text
RD> search in the manual for "read only" did not y
Hi,
I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a
password is required for access.
Both GRANT and REVOKE give errors saying "Table 'User' is read only". A text
search in the manual for "read only" did not yield anything.
Is this an OS attribute that should be dealt with ma