Try

C:\mysqladmin -u [EMAIL PROTECTED] -p password newpassword

or even

C:\mysqladmin -u myaccount -h 127.0.0.1 -p password newpassword


----- Original Message -----
From: "Ardianto Rustandi" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 11:16
Subject: Re: Can't change password in MySQL Windows version


> This was what I did:
>
> As root:
> mysql>GRANT ALL ON mydb.* to [EMAIL PROTECTED] identified by
'mypassword';
> mysql>FLUSH PRIVILEGES;
>
> Trying to change myaccount's password from mysqladmin:
> C:\mysqladmin -u myaccount -p password newpassword
> Enter password: **********
> C:\MYSQL\BIN\MYSQLA~1.EXE: unable to change password; error: 'Can't find
any
> matching row in the user table'
>
> Trying to change myaccount's password from mysql console (as myaccount):
> mysql> SET PASSWORD = PASSWORD('newpassword');
> ERROR 1133: Can't find any matching row in the user table
>
> Regards,
> Ardianto R.
>
> ----- Original Message -----
> From: Rolf Hopkins <[EMAIL PROTECTED]>
> To: Ardianto Rustandi <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
> Sent: Wednesday, May 30, 2001 8:01 AM
> Subject: Re: Can't change password in MySQL Windows version
>
>
> > It's a little difficult solving your problem as you have not provided as
> > with samples of the commands you used, but
> >
> > 1.  Check that the user exists in the first place.
> >
> > and
> >
> > 2. Did you use GRANT to set up a user in the first place?  Not just
insert
> a
> > user into the tables.
> >
> > ----- Original Message -----
> > From: "Ardianto Rustandi" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, May 29, 2001 23:32
> > Subject: Can't change password in MySQL Windows version
> >
> >
> > > Hello all!
> > >
> > > Can anyone help me why I cannot change a user's password in the
Windows
> > > version of MySQL (except for the root account)? I keep getting the
> "ERROR
> > > 1133: Can't find any matching row in the user table" error message
> > everytime
> > > I try to change a user's password, both from mysqladmin and from SET
> > > PASSWORD command. FYI I'm using version 3.23.28-gamma running on
Win98.
> > >
> > > Thanx in advance!
> > > Ardianto Rustandi
> > >
>
>
>
>
> ---------------------------------------------------------------------
> 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


---------------------------------------------------------------------
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

Reply via email to