At the moment PHP mysqli connector does not have support for caching_sha2_password. We will have to use mysql_native_password until the PHP 7.4 is revised to support caching_sha2_password.
Installation of php 7.4
Code:
sudo su
apt install -y software-properties-common
add-apt-repository ppa:ndrej/php
apt update
apt -y install php7.4Installation of Zoneminder
To install Zoneminder Please refer Connor's web site
Code:
sudo add-apt-repository ppa:iconnor/zoneminder-master
sudo apt-get update
sudo apt install zoneminder
rm /etc/mysql/my.cnf
cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/my.cnf
sed -i "15i default_authentication_plugin= mysql_native_password" /etc/mysql/my.cnf
/etc/init.d/mysql start
mysql
CREATE USER 'zmuser'@localhost IDENTIFIED WITH mysql_native_password BY 'zmpass';
GRANT ALL PRIVILEGES ON zm.* TO 'zmuser'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES ;
quit
mysqladmin -uroot -p reload
chmod 740 /etc/zm/zm.conf
chown root:www-data /etc/zm/zm.conf
adduser www-data video
a2enmod cgi
a2enconf zoneminder
a2enmod rewrite
chown -R www-data:www-data /usr/share/zoneminder/
systemctl enable zoneminder
service zoneminder start
service apache2 reload