How to reset Mysql Password

//** STEPS ARE AS FOLLOWS **// :-

----------********-----------

**********How to reset Mysql root password on directadmin server:--


#mysql --user=`grep "^user=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --password=`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2`


mysql>use mysql


mysql>update user set password=PASSWORD("newpassword") where User='root';

----------********-----------