Rick: I believe this is a faq, but check permissions. bash-2.05$ ls -lrtd /mysql/ drwxr-x--- 42 mysql mysql 4096 May 1 11:34 /mysql/
[root@winslow RPMS]# ls -lrt /var/lib/mysql/ total 12 drwx------ 2 mysql mysql 4096 May 24 22:01 test -rw-rw---- 1 mysql mysql 146 May 24 22:01 winslow.log drwx------ 2 mysql mysql 4096 May 24 22:01 mysql srwxrwxrwx 1 mysql mysql 0 May 24 22:01 mysql.sock The first invocation from a source distro. The second from a binary RH 7.2 installation. Send the about to the list, and someone should be able to give the command to fix your problem to you. Regards, Van -- ================================================================= Linux rocks!!! http://www.dedserius.com/ ================================================================= Richard Davidson wrote: > > 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 manually, such as with > Windows-NT explorer or DOS ATTRIB? Or is there a MySQL command that should > be used to make tables read-only and read-write? > > Thanks, > Rick > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php