Reset the MariaDB Root Password

mysql --version

sudo systemctl stop mariadb

sudo systemctl set-environment MYSQLD_OPTS="--skip-grant-tables --skip-networking"

sudo systemctl start mariadb

sudo systemctl status mariadb.

sudo mysql -u root

FLUSH PRIVILEGES;

use mysql;

UPDATE mysql.user SET password = PASSWORD('new_password') WHERE user = 'root';

UPDATE mysql.user SET authentication_string = '' WHERE user = 'root';
UPDATE mysql.user SET plugin = '' WHERE user = 'root';

FLUSH PRIVILEGES;

exit

 

 flush privileges;