Cambiar clave de Usuario

Usar la base de datos mysql

 mysql> use mysql;

Cambiar clave:

 SET PASSWORD FOR 'user-name-here'@'hostname-name-here' = PASSWORD('new-password-here');

O también:

 UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE User='user-name-here' AND Host='host-name-here';

Confirmación de cambio:

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0