On Wed, 12 Jun 2002, Francisco Reinaldo wrote:
> Fine, I can see the database, show tables works,
> selects works. The whole nine yards? Nope! I cannot
> insert any values in that database. I get the
> following error: "Table xxx is read only". I have
> checked the OS permission for that directory and I
> have given full persmission (write, read and execute).
> Also I have checked MySQL permissions, adding full
> permission for all users to that database but nothing.
> It looks like the problem is at the table level
> because when I manually add a new table to the MySQL
> UNIX, the inserts work.
The only reason this can happen is wring permission bits no tables.
Internally there is no way to make MyISAM (I assume you use them)
read-only. Look as which user mysqld runs and make tables writable to that