Still couldn't do it... :(
Might this be a bug in MySQL Windows (or the particular version I'm using--
3.23.28-gamma)?
Ardianto R.
> 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.
> >
---------------------------------------------------------------------
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
