Reset Forgotten MySQL Root Password

[Metalik]

Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords

mysqld_safe –skip-grant-tables

mysql –user=root mysql

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

Now kill your running mysqld, then restart it normally

[secure_host]

مقاله ای نیز در لینک زیر موجود است .
فراموشی و تغییر رمز root در mysql