MariaDB

An open source Relational DataBase Management System forked from mySQL.

Root login
This process allows to reset a root password, or change the authentication method to UNIX socket.

Stop service sudo systemctl stop mariadb

Start without permission checking sudo mysqld_safe --skip-grant-tables --skip-networking &

Connect as root mysql -u root

Clear privileges FLUSH PRIVILEGES;

Set type of login

Kill process sudo kill `/var/run/mariadb/mariadb.pid`

Restart in normal mode sudo systemctl start mariadb

]