Link
  1. Reset MySQL Password without root password

Reset MySQL Password without root password

# stop the mysql service
service mysql stop

# start the mysqld_safe service
mysqld_safe --skip-grant-tables --skip-networking &

# now connect to the mysql server as root, with NO password
mysql -u root

# now reset the password
mysql> use mysql;
mysql> update user set authentication_string=password('QWERTY123') where user='root';
mysql> flush privileges;
mysql> quit
# password changed
# restart the mysql service
# done!

Resources and More