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#');