Using MariaDB
To improve the security of MariaDB and change the root user password, remove the anonymous user, restrict root user access to the local machine and remove the test database, run the following command:
sudo mysql_secure_installation
MariaDB root login details are:
User: root
Pass: blank (no password set)
Documentation on using MariaDB and the pre installed tools can be found on the following links:
MariaDB Documentation:
https://mariadb.org/documentation/
Using HeidiSQL:
https://www.heidisql.com/#featurelist
Using MySQL Workbench:
https://dev.mysql.com/doc/workbench/en/