Let me try again. I recently installed mysql. I need to change the root password. However, whatever method I try mysql tell me that the user table is read only.
> mysqladmin -u root password 'mynewpassword' mysqladmin: unable to change password; error: 'Table 'user' 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: > 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 read only? > Thanks --------------------------------------------------------------------- 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
