Forgot MariaDB Password – Fix: sudo mariadb -u root

Forgot your MariaDB password? Luckily, you don’t need password for administrative access.

$ sudo mariadb -u root

$ sudo mariadb -u root
MariaDB [hats]> CREATE DATABASE yesimdbroot;
Query OK, 1 row affected (0.00 sec)

Well done, you’re now database root.
For normal use, remember to ‘exit’ and create a normal (non db root) user and database. What next? MariaDB installation and CRUD notes.