11.2.2011
mysqldatabase managementsystem administration

The webpage provides a tutorial on how to reset a forgotten MySQL root password. It outlines a step-by-step process, which requires root access to the server, stopping the MySQL daemon, bypassing the grant tables storing passwords, connecting to MySQL without a password, setting the new password, and restarting MySQL normally.

update user set Password=PASSWORD(‘new-password’) where user=‘root’;

http://www.howtoforge.com/reset-forgotten-mysql-root-password