USE `mysql`;
UPDATE `user` SET `password` = PASSWORD('passwd') WHERE `user` = 'root';
FLUSH PRIVILEGES;