Change mysql user password

mysql> SET PASSWORD FOR root@localhost=PASSWORD('rubberchicken');