Install MariaDB Server 10.0

From ZoneMinder Wiki
Revision as of 15:48, 21 April 2016 by Bbunge (talk | contribs)
Jump to navigationJump to search

Install MariaDB Server 10.0 on Ubuntu 16.04.

21APR16 This has not been tested with teh final release of Ubuntu 16.04

As of this writing, Ubuntu 16.04 has included MySQL 5.7. The easy replacement of MySQL with Mariadb does work.

However you can manually install LAMP with Mariadb.

To manually install LAMP start with a Ubuntu 16.04 Basic Server install.

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/mariadb.conf.d/50-server.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 https://wiki.zoneminder.com/Ubuntu_Server_16.04_64-bit_with_Zoneminder_1.29.0_the_easy_way#Install_Zoneminder

Retrieved from "https://wiki.zoneminder.com/index.php?title=Install_MariaDB_Server_10.0&oldid=7631"