Change Forgotten MariaDB Root Password

This article details how to reset a forgotten MariaDB root password. I am not shedding any new light to this, this is here for a quick reference for me. The source of this excellent article is at the bottom of the page.

Stop the service and start MariaDB in safe mode.

service mariadb stop
mysqld_safe --skip-grant-tables &amp;

There may be a slight hang, just type mysql

# mysql

MariaDB [(none)]&gt; use mysql;
MariaDB [mysql]&gt; UPDATE user SET password=PASSWORD("new_password") WHERE User='root';
MariaDB [mysql]&gt; FLUSH PRIVILEGES;
MariaDB [mysql]&gt; quit;

Restart the service.

service mariadb restart

Logon as root with the new password.

[root@myserver~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 260
Server version: 5.5.50-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]>

Source(s)
http://tecadmin.net/steps-to-reset-mariadb-root-password-in-linux/#