I'm having similar issues with Zoneminder not starting:
root@30404418888a:/# service mysql start
* Starting MariaDB database server mysqld [ OK ]
root@30404418888a:/# service zoneminder start
Starting ZoneMinder:
06/24/23 10:38:06.166412 zmpkg[22796].INF [main:318] [Sanity checking States table...]
DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/share/perl5/ZoneMinder/Logger.pm line 627.
06/24/23 10:38:06.234656 zmpkg[22796].ERR [ZoneMinder::Logger:630] [Can't execute log entry 'INSERT INTO Logs ( TimeKey, Component, ServerId, Pid, Level, Code, Message, File, Line ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, NULL )': Lost connection to MySQL server during query]
DBD::mysql::st execute failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/bin/zmpkg.pl line 325.
06/24/23 10:38:06.234864 zmpkg[22796].FAT [main:325] [Can't execute: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)]
ZoneMinder failed to start