Re: Unable to change password

Hi!

On Mar 19, Dr. R. Rajaraman wrote:
> Dear Sergei,
>
> Hope you remember me (TRUNCATE table bug fellow!).

Yes, sure.

First - sorry for delayed answer.
I'm really overflowed with emails so it's impossible to answer personal
emails in a timely manner. Please use bugs@lists.mysql.com to report
bugs.

> My new problem is not able to change the password. I remember I did it while
> using the previous version of mysql.
>
> My configuration is:
> Windows 2000 prof, apache, PHP4.3, Mysql 4.0.11-gamma, phpmyadmin 2.4.0.
>
> Looking forward to your reply
> -rajaraman
>
> Here is the dump.
> -----------------------------
> E:\mysql\bin>mysql -u rraman -p mysql
> Enter password: ********
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 145 to server version: 4.0.10-gamma-nt
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> select database();
> +------------+
> | database() |
> +------------+
> | mysql |
> +------------+
> 1 row in set (0.00 sec)
>
> mysql> show grants for rraman@localhost;
> +----------------------------------------------------------- ------------------------------------------------------+
> | Grants for rraman@localhost |
> +----------------------------------------------------------- ------------------------------------------------------+
> | GRANT ALL PRIVILEGES ON *.* TO 'rraman'@'localhost' IDENTIFIED BY PASSWORD '01a2cd9036490ea8' WITH GRANT OPTION |
> +----------------------------------------------------------- ------------------------------------------------------+
> 1 row in set (0.00 sec)
>
> mysql> set password = password('test123');
> ERROR 1133: Can't find any matching row in the user table

What is the output from

SELECT CURRENT_USER()

?

And one more idea - try executing

FLUSH PRIVILEGES

before changing password - in case privilege tables were modified
without GRANT command.

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org