Connecting WM to MariaDB

MariaDB is a fork of MySQL led by the latter's original developers. It is designed to be a drop-in replacement and thus can be used, as one would expect, with little adjustment to the configuration of WhatManager.

Installation

I install MariaDB 10.1 by following the repository configuration tool.

Setup

In setup.sh, replace the package libmysqlclient-dev with libmariadbclient-dev. All other steps should be followed as in the main setup guide.

In Debian 9

You won't be able to use the root mariadb user, as it requires sudo privileges. At step 10 of https://github.com/karamanolev/WhatManager2/wiki/Installing-WM-Core, create the database as sudo, then log into mariadb with sudo mariadb -u root -p. The following commands will create a user and give it privileges on what_manager2:
CREATE USER 'username'@'localhost' IDENTIFIED BY 'userpassword';
GRANT ALL PRIVILEGES ON what_manager2.* to 'username'@'localhost';
FLUSH PRIVILEGES;
Don't forget to set the correct mariadb user in settings.py