Did you
1. Use GRANT to create the user? If you didn't and inserted data
incorrectly into the grant tables, you could find problems later on.
2. Flush privileges after creating the user?
----- Original Message -----
From: "Martin RODOT" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 28, 2001 15:41
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
