This assume you are able to connect to MariaDB. You may want to first SELECT USER to display the list of current users.

UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='the_username';
FLUSH PRIVILEGES;