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}