====== MySQL: Change Password ======

  * Replace ''{passwd}'' with the password of the user.
  * Replace ''{user}'' with the name of the user.

<code sql>
GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{passwd}';
FLUSH PRIVILEGES;
</code>

Or you can alternatively use the following:

<code sql>
UPDATE mysql.user SET Password=PASSWORD('{passwd}') WHERE User='{user}';
FLUSH PRIVILEGES;
</code>

{{tag>admin database mysql password sql}}