readd zoneminder mysql user(s)
mysql -e "ALTER USER 'zemerdon'@localhost IDENTIFIED BY 'passwordhere';
mysql -e "ALTER USER 'zmuser'@localhost IDENTIFIED BY 'zmpass';"
mysql -e "GRANT ALL PRIVILEGES ON zm.* TO 'zmuser'@'localhost' WITH GRANT OPTION;"
Create admin for phpmyadmin
mysql -u root
CREATE USER 'zemerdon'@'localhost' IDENTIFIED BY 'passwordhere';
GRANT ALL PRIVILEGES ON * . * TO 'zemerdon'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
BACKUP MYSQLDB
mysqldump --user=XXXXXXXX --password=XXXXXXX --databases zm > /PATH/TO/DUMPFILE.SQL
mysqldump -u [username] -p --all-databases > alldatabases_backup.sql
root@nvr:/home# mysqldump --user=root --password=passwordhere --all-databases > /home/zoneminder_16-05-2023_v1.36.33.sql
RESTORE MYSQLDB
mysql --user=XXXXXXXX --password=XXXXXXXX zm < /PATH/TO/DUMPFILE.SQL
mysql -u [username] -p < /path/to/your/all_databases.sql