ERROR juju.worker.uniter.operation hook "monitors-relation-joined"

[erik78se]

Following the guide on the "Nagios" charm, referencing this charm.

https://jaas.ai/nagios/42

juju deploy nagios
juju deploy mysql
juju relate mysql nagios"

Logs:

juju debug-log --include mysql/0

unit.mysql/0.monitors-relation-joined ERROR 1133 (42000) at line 1: Can't find any matching row in the user table

unit-mysql-0: 13:24:41 INFO juju.worker.uniter awaiting error resolution for "relation-joined" hook
unit-mysql-0: 13:24:42 WARNING unit.mysql/0.monitors-relation-joined mysql: [Warning] Using a password on the command line interface can be insecure.
unit-mysql-0: 13:24:42 WARNING unit.mysql/0.monitors-relation-joined ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
unit-mysql-0: 13:24:42 ERROR juju.worker.uniter.operation hook "monitors-relation-joined" (via explicit, bespoke hook script) failed: exit status 1
unit-mysql-0: 13:24:42 INFO juju.worker.uniter awaiting error resolution for "relation-joined" hook
unit-mysql-0: 13:25:59 INFO juju.worker.uniter awaiting error resolution for "relation-joined" hook
unit-mysql-0: 13:25:59 WARNING unit.mysql/0.monitors-relation-joined mysql: [Warning] Using a password on the command line interface can be insecure.
unit-mysql-0: 13:25:59 WARNING unit.mysql/0.monitors-relation-joined ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
unit-mysql-0: 13:25:59 ERROR juju.worker.uniter.operation hook "monitors-relation-joined" (via explicit, bespoke hook script) failed: exit status 1
unit-mysql-0: 13:25:59 INFO juju.worker.uniter awaiting error resolution for "relation-joined" hook
^[unit-mysql-0: 13:28:30 INFO juju.worker.uniter awaiting error resolution for "relation-joined" hook
unit-mysql-0: 13:28:30 WARNING unit.mysql/0.monitors-relation-joined mysql: [Warning] Using a password on the command line interface can be insecure.
unit-mysql-0: 13:28:30 WARNING unit.mysql/0.monitors-relation-joined ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
unit-mysql-0: 13:28:30 ERROR juju.worker.uniter.operation hook "monitors-relation-joined" (via explicit, bespoke hook script) failed: exit status 1

[erik78se]

I have also submitted a bug on the nagios charm.

https://bugs.launchpad.net/charm-nagios/+bug/1922486