Change root password in MySQL

- When you want to access mysql via command-line, you must use ---> mysql -uroot -p instead of ---> mysql -u root -p

- To change root password --->

$ mysql -uroot -p

mysql> use mysql;

mysql> update user set password=PASSWORD("NEWPASSWORD") where User='USER';

To reload privileges:

mysql> flush privileges;

mysql> quit