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
