mysql user table is read only by root

27; is read only' Or mysql> UPDATE user SET Password='mynewpassword' where User='root'; ERROR 1036: Table 'user' is read only Any idea on how I can go about replacing root's password? Thanks Ari on 2/25/02 1:41 AM, Ari Kahn at [EMAIL PROTECTED] wrote

user table read only by root?

I'm trying to use mysqladmin to change root's password. I am root. However, when I used the command I get the following error mysqladmin: unable to change password; error: 'Table 'user' is read only' This happens no matter what method I try to change the user table. How can I make a table not rea