Requesting a new Password for Uid 1 when you are running a local server on your computer

Hi there,

I am running MAMP Pro on my Mac to create a local server for my site. I need to reset the Uid 1 password but how do I do that. I requested the site to send me a new password but I am not sure if it will go through since I am running a local server on my machine. I looked at changing the password with this command line but it doesn't work..

UPDATE users SET pass ='thepasswordhash' WHERE uid = 1;

The old password is a really long like this... $S$CTo9G7Lx28rzCfpn4WB2hUlknDKv6QTqHaf82WLbhPT2K5TzKzML

but when I type a new one in it is just stays as a regular word that I type in.

Any help would be very helpful.

thanks,

tom