Change MySQL Root Password

Last updated on June 19, 2015

Below are the steps to change MySQL user passwood,

Setup for first time the root password:

mysqladmin -u root password YOUR_PASSWORD

Change existent root password:

mysqladmin -u root -p'oldpass' password 'newpass'

Change password for an existent user:

mysqladmin -u user -p 'oldpass' password 'newpass'

Change password using MySQL commands:

update user set password=PASSWORD("YOUR_NEW_PASS") where User='arjun';
flush privileges;