----- Original Message -----
From: "Rochester, Dean" <[EMAIL PROTECTED]>
To: "MySQL (E-mail) (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, October 01, 2002 8:22 PM
Subject: Table says it is read only but it is not from file system level
> 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
Hmm, peculiar permissions. Why is everything world-readable? If the "mysql"
database it too, you could be in jeopardy.
> 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 remember something about compressed databases becoming read-only. Perhaps
that is the case?
> I am using java to do this sql operation.
Is that why you made everything world-readable, because you thought the
web-daemon would need access? That should not be. The web-daemon will
connect over socket (or tcp) to the MySQL server. As long as the databases
are owned by the mysql user (if that is what the MySQL daemon runs as), you
are okay; use chmod 660 (or perhaps 600 even).
- Mark
System Administrator Asarian-host.org
---
"If you were supposed to understand it,
we wouldn't call it code." - FedEx
---------------------------------------------------------------------
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
