Install MySQL 5.6 on Debian Jessie

From ZoneMinder Wiki
Jump to navigationJump to 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