Update mysql user password

mysql> ALTER USER 'user-name'@'some_host_ip' IDENTIFIED BY 'NEW_USER_PASSWORD';
mysql> FLUSH PRIVILEGES;

For earlier versions of mysql (mysql 5.7.6 or MariaDB 10.1.20 and earlier):

mysql> SET PASSWORD FOR 'user-name'@'localhost' = PASSWORD('NEW_USER_PASSWORD');
mysql> FLUSH PRIVILEGES;