You did not properly invoke the PASSWORD() function:
UPDATE user SET password=PASSWORD('somepass') WHERE user='root';
On Mon, 21 Jan 2002 11:04:57 +0100, Aleksandar Bradaric wrote:
>Hi,
>
>> I tried to set the root password in the mysql db;
>> update user set Password='password' where User='root';
>
>MySQL encrypts passwords, so your update statement is
>useless. Try using GRANT... :)
>
>
>Regards,
>Sasa
>
>
>
>---------------------------------------------------------------------
>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
