Setting the root password

mysql> UPDATE mysql.USER SET Password=PASSWORD('MyNewPass')
    ->                   WHERE USER='root';
mysql> FLUSH PRIVILEGES;