Reset Mysql Root Password

Often we forget the root password for the mysql, here is a way you can reset the mysql root password.

1) 
kill mysqld without -9 option

2) 
start mysqld with --skip-grant-tables  option

3) 
mysql --user=root --port=3306  --host=server1

4) 
  use mysql;
  update user set password=PASSWORD("letmein") where User='root';
  flush privileges;
  quit
OR 
   mysqladmin -u root flush-privileges password "letmein"

5) 
start mysqld with your regular option

• mysql
• database