====== MySQL - Change passwords ======

===== Change root password =====

<code mysql>
mysql> use mysql;
mysql> update user set password=password("new-password") where user = "root";
mysql> flush privileges;
</code>

You may accomplish the same task with mysqladmin MySQL command.

<code bash>
$ mysqladmin -u root password 'new-password'
</code>

If you wish to change existing root password, you'll use the following command instead. When entered, you'll be prompted for current root password.

<code bash>	
$ mysqladmin -u root -p password 'new-password'
</code>

**NOTE**:  You do not have to run "flush privileges" MySQL command to reload the privileges when you use "mysqladmin" command.