Lost MySQL Admin Password

I lost mysql admin (root user) password. How do I reset a lost MySQL admin (root) password under UNIX or Linux or BSD operating systems?

Type the following commands. First, stop current MySQL database server:

/etc/init.d/mysql stop

OR

/etc/init.d/mysqld stop

OR

/usr/local/etc/rc.d/mysql-server stop

Now, start mysql server without password so that you can restart the password:

mysqld_safe --skip-grant-tables &

Login without a password, enter:

mysql -u root

Finally, setup a new MySQL root user password, enter::

USE mysql;

UPDATE user SET password=PASSWORD("NEW-ROOT-PASSWORD") WHERE User='root';

FLUSH privileges;

quit

Replace NEW-ROOT-PASSWORD with actual password you want to use. Restart running mysql server:

/etc/init.d/mysql restart

Test it:

mysql -u root -p