Difference between revisions of "Install MariaDB Server 10.0"

From ZoneMinder Wiki
Jump to navigationJump to search
(Created page with "Install MariaDB Server 10.0. This replaces MySQL 5.6. It will use the current configuration file (my.cnf) and current databases. MariaDB has some enhanced features which do no...")
 
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
Install MariaDB Server 10.0. This replaces MySQL 5.6. It will use the current configuration file (my.cnf) and current databases. MariaDB has some enhanced features which do not exist in MySQL and thus migration back to MySQL might not always work.
'''Install MariaDB Server 10.0 on Ubuntu 16.04.'''


apt-get install mariadb-server    (MySQL will be removed)
See this: https://wiki.zoneminder.com/Ubuntu_Server_16.04_64-bit_with_Zoneminder_1.30.0_the_easy_way#Optional_Upgrade_to_MariaDB_Server_10.0._before_installing_Zoneminder
 
'''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:
 
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

Latest revision as of 14:24, 1 October 2016