Changing the Root Password of MySQL.

We are going to see how to change the root password of MySQL.

Method 1:

$ mysqladmin -u root password

How to change a Root Password.

$ mysqladmin -u root -p 'abc' password '123456';

Ex: mysql -u root -p 'abc' -e 'show databases';

mysqladmin -u root -p 'abc' password '123456'

Changing MySQL Password for other users.

$ mysqladmin -u manish -p 'oldpassword' password newpassword;

Method 2:

Change mysql root user password using the mysql command.

$ mysql -u root -p

mysql> USE mysql;

mysql> Update user set password = PASSWORD('NEWPASSWORD') where user='root';

mysql> Flush Privileges;

mysql> exit