At 3:06 PM -0700 8/22/99, Gagan Palrecha wrote:
>Hi,
>
>I just downloaded the shareware win32 mysql. I'm running win 98.
>
>Well, I ran:
>c:\mysql\bin\mysqld
>this was fine.
>then I opened up mysql -uroot mysql.
>That was fine as well. then I typed:
>DELETE FROM user WHERE Host='localhost' AND User='';
>I did this because in the Documentation is said to do this in order to
>change the root password.
>Then I continued and changed the root password by:
>UPDATE user SET Password='gagan'WHERE User='root';
You're supposed to set password values with PASSWORD('gagan'),
not just 'gagan'.
--
Paul DuBois, paul@stripped
