1.35.18~20210210170809-focal -problem in creating zm user and getting zm panel

[bkjaya1952]

I have done a test run on Zoneminder master 1.35.18~20210210170809-focal issued yesterday using a usb camera.

When creating zmuser using the following command , there was an error as shown below

mysql -e "CREATE USER 'zmuser'@localhost IDENTIFIED BY 'zmpass';"

ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'zmuser'@'localhost'

When ALTER is instead of CREATE , zmuser the new zmuser was created ( mysql -e "ALTER USER 'zmuser'@localhost IDENTIFIED BY 'zmpass';" )

Then I got the ZM_WEB_TITLE Login screen then stuck on the privacy screen without getting the zm panel.

Screenshot from 2021-02-11 12-08-02.png (37.28 KiB) Viewed 1238 times

Screenshot from 2021-02-11 12-08-37.png (202.35 KiB) Viewed 1238 times

Therefore I had to drop the zm database using the following command and re do the mysql zm configuration from the beginning.

mysql -e "drop database zm;"

Conclution:-

You will have to drop the exiting zm database before configuring mysql for zm