Upgrade error

[siki]

Hi
upgrade attempt let my system unusable...

------------------------------------------------
siki@siki:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.4 LTS
Release: 16.04
Codename: xenial

siki@zmhost:~$ sudo zmupdate.pl
Upgrading database to version 1.31.44
Loading config from DB 222 entries
Saving config to DB 222 entries
Upgrading DB to 1.31.2 from 1.31.1

Database successfully upgraded to version 1.31.2.
Upgrading DB to 1.31.3 from 1.31.1

Database successfully upgraded to version 1.31.3.
Upgrading DB to 1.31.4 from 1.31.1

Database successfully upgraded to version 1.31.4.
Upgrading DB to 1.31.5 from 1.31.1

Database successfully upgraded to version 1.31.5.
Upgrading DB to 1.31.6 from 1.31.1

Database successfully upgraded to version 1.31.6.
Upgrading DB to 1.31.7 from 1.31.1

Database successfully upgraded to version 1.31.7.
Upgrading DB to 1.31.8 from 1.31.1

Database successfully upgraded to version 1.31.8.
Upgrading DB to 1.31.9 from 1.31.1

Database successfully upgraded to version 1.31.9.
Upgrading DB to 1.31.10 from 1.31.1

Database successfully upgraded to version 1.31.10.
Upgrading DB to 1.31.11 from 1.31.1

Database successfully upgraded to version 1.31.11.
Upgrading DB to 1.31.12 from 1.31.1

Database successfully upgraded to version 1.31.12.
Upgrading DB to 1.31.13 from 1.31.1

Database successfully upgraded to version 1.31.13.
Upgrading DB to 1.31.14 from 1.31.1

Database successfully upgraded to version 1.31.14.
Upgrading DB to 1.31.15 from 1.31.1

Database successfully upgraded to version 1.31.15.
Upgrading DB to 1.31.16 from 1.31.1

Database successfully upgraded to version 1.31.16.
Upgrading DB to 1.31.17 from 1.31.1

Database successfully upgraded to version 1.31.17.
Upgrading DB to 1.31.18 from 1.31.1

Database successfully upgraded to version 1.31.18.
Upgrading DB to 1.31.19 from 1.31.1
ERROR 1370 (42000) at line 1: alter routine command denied to user 'zmuser'@'localhost' for routine 'zm.update_storage_stats'
Output:
Command 'mysql -hlocalhost -uzmuser -p"zmpass" zm < /usr/share/zoneminder/db/zm_update-1.31.19.sql' exited with status: 1


best regards
Davor

[iconnor]

echo "grant lock tables,alter,drop,select,insert,update,delete,create,index,alter routine,create routine, trigger,execute on ${ZM_DB_NAME}.* to '${ZM_DB_USER}'@localhost;" | mysql --defaults-file=/etc/mysql/debian.cnf mysql