Install MariaDB Server 10.0

Install MariaDB Server 10.0 on Ubuntu 16.04.

09APR16

As of this writing, Ubuntu 16.04 has included MySQL 5.7. The easy replacement of MySQL with Mariadb does not work. Therefore you should start with a basic Ubuntu 16.04 server install with no LAMP.

To manually install LAMP

Become root

sudo su

Install Apache

apt-get install apache2

Install Mariadb server

apt-get install mariadb-server

Install PHP

apt-get install php libapache2-mod-php php7.0-mysql

Secure Mariadb, create root password et. al.

mysql_secure_installation

Note: The MySQL/MariaDB configuration file is located at: /etc/mysql/mysql.conf.d/mysqld.cnf To better manage the MariaDB server I recommend you move the config file and replace the default my.cnf symbolic link (this also works for MySQL 5.6).

rm /etc/mysql/my.cnf  (this removes the current symbolic link)

cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/my.cnf

To change Mariadb settings:

nano /etc/mysql/my.cnf

Ctrl+o Enter to save

CTRL+x to exit

A tool that you may want to install is mysqltuner. This is handy to see what database paramaters need to be adjusted as your ZM system builds up events.

apt-get install mysqltuner

Once installed, run mysqltuner from a command prompt as root (sudo). Edit the configuration file and make the recommended changes. Stop zoneminder, restart the database server then start zoneminder.

Continue installing Zoneminder Back to 16.04/1.29.0 setup: https://wiki.zoneminder.com/Ubuntu_Server_16.04_64-bit_with_Zoneminder_1.29.0_the_easy_way