How to change the user password in MySQL or MariaDB

Change the password of a user with ALTER USER statement

Note: Backup the user password before changing if necessary: open the link

mysql -u root -p
mysql> ALTER USER hr@localhost IDENTIFIED BY 'Password1';
mysql> FLUSH PRIVILEGES;

Change Password for User with SET PASSWORD command

Syntax:
SET PASSWORD [FOR user] = password_option

password_option: { 'auth_string'
 | PASSWORD('auth_string') }

Example:
--For Current User
SET PASSWORD = 'Pasword1';
FLUSH PRIVILEGES;

--Use latest command above version 5.7.6
SET PASSWORD FOR 'hr'@'localhost' = Password1;
FLUSH PRIVILEGES;

--For older version use PASSWORD() function (its deprecated above version 5.7.6)
SET PASSWORD FOR 'hr'@'localhost' = PASSWORD('Password1');
FLUSH PRIVILEGES;

Check Current user

SELECT CURRENT_USER();

Change the Password of the user with the UPDATE command

---Use latest command used above version 5.7.6
USE mysql;
UPDATE user SET authentication_string = PASSWORD('Password1')
 WHERE user = 'hr' AND host = 'localhost';
FLUSH PRIVILEGES;

--For older version below 5.7.6
user mysql;
UPDATE user 
SET password = PASSWORD('Password1')
 WHERE user = 'hr' AND 
host = 'localhost';
FLUSH PRIVILEGES;

Verify the new password of the user by login

$mysql -u username -h localhost -p