Password setting

Am I missing something with this attempt to change the password on mysql (this is on NT):

SET PASSWORD FOR root = PASSWORD("newpass");

gives error

parse error near PASSWORD FOR root = PASSWORD("newpass");

Any ideas?

Thanks...Stephen

Hello,
Try this one:

Update user set Password=Password('xxxxxxx') where user='root';

...and then restart the server for it to take effect.