How to change MySQLAdmin(root) Password using MySQL Safe Mode

Reset MySQL Admin Password using MySQL Safe Mode….

First you must Stop/Kill existing MySQL service or PIDs

#service mysqld stop or
#killall mysqld

Now Start MySQL in Safe Mode using Following Command

#/usr/bin/mysqld_safe --user=mysql --skip-grant-tables

Now Connect to MySQL

#/usr/bin/mysql

Use the mysql database:

mysql>use mysql;

Change the MySQL admin(root) Password using following command

mysql>update user set password=password(‘wsarxaffa’) where user=’root’ and host=’localhost’;

Flush the privileges so everything will take (It removes any privileges set by the server)

mysql>flush privileges;

Then Quit : mysql>quit

Stop MySQL Service

/etc/init.d/mysqld stop

Start MySQL Service

/etc/init.d/mysqld start

Now Login to MySQL As A root user

#mysql -u root -p wsarxaffa