Martin,
You should try the following. It's work for me.
mysql> connect mysql;
mysql> update user set password=PASSWORD('newpassword') where user='auser';
mysql>FLUSH PRIVILEGES;
Regard,
Emanduel Chan
----- Original Message -----
From: "Martin RODOT" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 28, 2001 3:41 PM
Subject: changing pasword
> Hi !
>
> I'm using MySql 3.23.38-nt on a test machine.
>
> I'd like to create a new user and I tried :
>
> ----------------------------------
> mysql> connect mysql
> Connection id: 308
> Current database: mysql
>
> mysql> set password for auser = password("anewpassword");
> ERROR 1133: Can't find any matching row in the user table
> ---------------------------------------------------------------
>
> But I have actually created the user and I can see :
>
>
> mysql> select * from user where user = "auser";
> +-----------+---------+------------------+-------------+------------
> | Host | User | Password | Select_priv | Insert_priv
> +-----------+---------+------------------+-------------+------------
> | localhost | auser | 5f1839b1118fb243 | Y | Y
> +-----------+---------+------------------+-------------+------------
> 1 row in set (0.00 sec)
> mysql>
>
>
> Of course I was connected as super-user with all privileges.
>
> Does anybody can explain me what is wrong ?
>
> Regards.
>
> Martin RODOT
> M.R.IT - BLOIS - France
>
> Welcome in Blois
>
> ---------------------------------------------------------------------
> 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