List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:August 22 1999 11:08pm
Subject:Re: mysql shareware question/problem
View as plain text  
At 3:06 PM -0700 8/22/99, Gagan Palrecha wrote:
>I just downloaded the shareware win32 mysql.  I'm running win 98. 
>Well, I ran:
>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
mysql shareware question/problemGagan Palrecha22 Aug
  • Re: mysql shareware question/problemPaul DuBois23 Aug