You are connecting th the server, not the table. The server must have read and write permissions on the files. They must be owned by mysql, as must their directories.
Rochester, Dean wrote: >I am running an sql insert against a mysql table version 3.23.52 > >When from the file system level the table has the following permissions. > >rw-rw-r-- table.frm >rw-rw-r-- table.MYD >rw-rw-r-- table.MYI > > >When the sql runs it says the table is read only. I am connecting to the >table as root and I have set the password too. > >I am using java to do this sql operation. > >I can select items from the table, but can not insert them. > >Thanks in advance >Dean-O > > > >--------------------------------------------------------------------- >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 > > > > --------------------------------------------------------------------- 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
