change MySQL root password

Posted under » MySQL » Ubuntu on 13 October 2009

If you already know the current password and want to change the root password, while at MySQL

SET PASSWORD FOR root@'localhost' = PASSWORD('taik');

If you have lost your root password, try this.