mariadb change password

SET PASSWORD - MariaDB Knowledge Base
https://mariadb.com/kb/en/set-password/#syntax

MariaDB: Change a user password
https://www.techonthenet.com/mariadb/change_password.php

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('abc123456');