Changing password on a MySQL DB

Hey man,

Below there is a good tip.

# mysql -u root -p

mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE User='root';
mysql> FLUSH PRIVILEGES;