List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 11 2002 7:35pm
Subject:Re: not able to edit table:((
View as plain text  
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
>>>
>>>


Thread
not able to edit table:((Anil Garg11 Jun
  • Re: not able to edit table:((Kiss D├íniel11 Jun
    • Re: not able to edit table:((Anil Garg11 Jun
      • Re: Re: not able to edit table:((Egor Egorov12 Jun
    • Re: not able to edit table:((Gerald Clark11 Jun