Open up a terminal windows. You will see a shell prompt with you user name in it. Type the following (not including the shell this is where your user name is displayed)
shell> cd /usr/local/mysql
Then
shell> ./bin/mysql -u root
If all is running OK you should get a MySQL propmpt like so...
mysql>
Now type the command
mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
With a bit of luck that should do the trick. If it doesn't let us know, I'm working blind as I'm at work at the moment but it should be all OK.
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information