How to Change Password in MariaDB by using SET Password

How to Change Password in MariaDB by using SET Password

To reset the password in MairaDB, below statment can be used.

Syntax:
MariaDB > SET PASSWORD FOR 'UserName'@'HostName' = PASSWORD('NewPassowrd');

Example : 
Let's say that we have user TB and we want to change the password to 'Pass123#' , below statement can be used in MariaDB to reset the password.
MariaDB > SET PASSWORD FOR 'TB'@'localhost' = PASSWORD('Pass123#');