How to change a MYSQL User Password

Solution

Step 1. Login to the relevant server as any user and login to mysql as described below

cd /usr/local/mysql/bin
./mysql -uroot

Change the user password

update mysql.user set password='indreport' where user='indreport';
Query OK, 0 rows affected (0.11 sec)
Rows matched: 1  Changed: 0  Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.00 sec)