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';