Re: mysql user table is read only by root

2002-02-25 Thread Benjamin Pflugmann
Hi. On Mon, Feb 25, 2002 at 11:22:22AM -0700, [EMAIL PROTECTED] wrote: > From: Ari Kahn <[EMAIL PROTECTED]> > > > > However, whatever method I try mysql tell me that the user table > > is read only. > > It sounds to me like "root" doesn't have sufficient permissions > granted to write to that

Re: mysql user table is read only by root

2002-02-25 Thread Rodney Broom
From: Ari Kahn <[EMAIL PROTECTED]> > However, whatever method I try mysql tell me that the user table > is read only. It sounds to me like "root" doesn't have sufficient permissions granted to write to that table, but I could be wrong. There's something in the docs about accessing after you'v

mysql user table is read only by root

2002-02-25 Thread Ari Kahn
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> U