Set mysql’s root password on fresh copy from SolusVM OS template

On SolusVM, your host may provide you with OS templates such as “Ubuntu 10.04 LTS LAMP” and you click-install it to your VPS. Now how do you change its mysql’s root password? simple, run these two commands on SSH after doing

mysql

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