==== Changing a users password ====

<sxh bash>
UPDATE mysql.user set Password=PASSWORD('newpassword') WHERE User='user' AND Host='x.x.x.x';
</sxh>

You are also able to use the following command, this will change the password for ALL users with the matching username, so you do not have to declare the host:
<sxh bash>
update mysql.user set password=PASSWORD('newpassword') where User='luke';
</sxh>