The mysql user was not granted write permission on the database?
Anil Garg wrote:
>The persmissions seems to be ok.
>ne other ideas!!
>----- Original Message -----
>From: "Kiss Dániel" <niel@stripped>
>To: "Anil Garg" <anilg@stripped>; <mysql@stripped>
>Sent: Tuesday, June 11, 2002 12:59 PM
>Subject: Re: not able to edit table:((
>
>
>>Greetings,
>>
>>Stop the MySQL server and check the table files.
>>I think they are read only if you use Win32, or under Linux the user
>>'mysql' does not have the write right to the tables or its directories
>>
>>In the last case:
>>chmod 660 *
>> and/or
>>chown mysql:mysql *
>>
>>At 12:39 2002.06.11. -0400, you wrote:
>>
>>>Hi,
>>>I am not able to edit a table:
>>>the sql queries i tried are follows:
>>>
>>>>delete form documents where id = 134; gives the following error:
>>>>
>>>error: table documents is read only
>>>
>>>repair doesnt seem to work
>>>repair table documents;
>>>Table Op Mst_type Msg_text
>>>mydb.documents repair error "the 'documents' is read only
>>>
>>>Can someone help me
>>>thanx
>>>anil
>>>
>>>