Install MySQL 5.6 on Debian Jessie

From ZoneMinder Wiki
Jump to: navigation, search

Install MySQL 5.6 on Debian Jessie and set up for Zoneminder


Download the MySQL APT repository config tool (you can see more details here: http://dev.mysql.com/downloads/repo/apt/)

For Debian 8 (make sure you are logged in as root):

wget http://dev.mysql.com/get/mysql-apt-config_0.3.5-1debian8_all.deb

Install the MySQL APT repository config tool

dpkg -i mysql-apt-config_0.3.5-1debian8_all.deb

You will be asked to select product and version that you want to install. In the first step, select Server and next select mysql-5.6. Then click Apply.

Update APT

apt-get update

Install the server

apt-get install mysql-community-server

(the procedure above is from: http://www.debiantutorials.com/install-mysql-server-5-6-debian-7-8/)

Edit the my.cnf file

nano /usr/my.cnf

locate and change to: sql_mode=NO_ENGINE_SUBSTITUTION

Ctrl+o Enter to save CTRL+x to exit

Install PHP

apt-get install php5 php-pear php5-mysql

Return to the Zoneminder Install and continue with adding the Jessie Backports http://www.zoneminder.com/wiki/index.php/Debian_8.1_64-bit_with_Zoneminder_1.28.1_the_Easy_Way