|Image courtesy: Mariadb.org|
MariaDB is a community fork of MySQL. Latest versions of Koha support MariaDB. Current versions of Ubuntu and Debian repository provide the old version of MariaDB. Users can add the latest version of MariaDB by adding the software repository. Here I try to install MariaDB 10.3 with an existing Koha installation on Ubuntu 16.04 LTS. MariaDB installation details can be found at mariadb.org. We can keep away DBMS auto increment problem by installing MariaDB latest version.
Installation of MariaDB
The process includes adding the MariaDB repository information to Ubuntu and install the database.
Open a terminal and apply the following commands one by one;
sudo apt-get update
sudo apt-get upgrade
Add MariaDB repository
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
Open the following file,
sudo leafpad /etc/apt/sources.list
Copy the following lines and put in the bottom of the file, save and close it.
# MariaDB 10.3 repository list - created 2018-07-17 13:56 UTC
deb [arch=amd64,arm64,i386,ppc64el] http://kartolo.sby.datautama.net.id/mariadb/repo/10.3/ubuntu xenial main
deb-src http://kartolo.sby.datautama.net.id/mariadb/repo/10.3/ubuntu xenial main
Update the repository and install MariaDB
sudo apt update
sudo apt install mariadb-server
Need to enter the Root password when the installation process ask. Give the same old MySQL root password.
After the installation try to Log into MariaDB,
mysql -uroot -p
If you find the following message,
ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded
Go to the following link and apply the solution mentioned in the forum,