use mysql

update user set password=PASSWORD('hooray') where user='root';

flush privileges;