Reset MariaDB Root Password

Para resetear la clave de Root de MariaDB seguiremos estos pasos:

$ sudo systemctl stop mariadb
$ sudo mysqld_safe --skip-grant-tables &

$ mysql -u root

$   use mysql;
$      update user SET PASSWORD=PASSWORD("password") WHERE USER='root';
$      flush privileges;
$      exit

$ sudo systemctl start mariadb

$ sudo systemctl stop mariadb

$ sudo mysqld_safe --skip-grant-tables &

$ mysql -u root

$ use mysql;

$ update user SET PASSWORD=PASSWORD("password") WHERE USER='root';

$ flush privileges;

$ exit

$ sudo systemctl start mariadb