systemctl stop mariadb
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables --skip-networking"
systemctl start mariadb
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY '-NEW_PASSWORD';
UPDATE mysql.user SET authentication_string = '-NEW_PASSWORD' WHERE user = 'root';
FLUSH PRIVILEGES;
systemctl unset-environment MYSQLD_OPTS
systemctl restart mariadb
mariadb -u root -p {NEW_PASSWORD}