Change mysql password from terminal

 

Set the MySQL Root password

mysqladmin -u root password “newpassword”
mysqladmin -u root -h host_name password “newpassword”

if you want to change (or update) a root password, then you need to use the following command:
 
 mysqladmin -u root -p'oldpassword' password newpass

Change MySQL password for other users

 mysqladmin -u nitish -p oldpassword password newpass

Login to mysql server, type the following command at shell prompt:

mysql -u root -p