Mysql Password Reset

Edit my.cnf and add the line "skip-grant-tables" in "[mysqld] section and restart the mysql. You can login to mysql without password.

To change the password execute following command @ mysql prompt.

mysql> update mysql.user set Password=PASSWORD('<>') where user='root';