How to set user password

Eg. for MySQL 4.0 ================= mysql > set password for some_user = password('newpassword'); where some_user uses the 'user@hostname' convention