How to set mysql root password

How to set mysql root password:

You can easily set the mysql root password...

# mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> exit


Now try to login with the password:

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.......
.......