forgot password for my mariadb user code example

Example: change password of user mariadb

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