How to asign a password in mariadb code example

Example: change password of user mariadb

UPDATE mysql.user SET Password=PASSWORD('New-Password') WHERE User='DB-UserName' AND Host='localhost';