Re: Read Only on User table

2002-05-27 Thread Benjamin Pflugmann
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

Re: Read Only on User table

2002-05-27 Thread Van
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

Re: Read Only on User table

2002-05-27 Thread Egor Egorov
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

Read Only on User table

2002-05-24 Thread Richard Davidson
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