Update the root password for mysql database

To update the password of mysql database for root user

1) Login in into mysql prompt.

mysql>UPDATE mysql.user SET Password=PASSWORD("*******") WHERE User="root";
mysql>FLUSH PRIVILEGES;

done.