Comment 6 for bug 1916672

Thanks for raising the bug:

Triage:

The charm needs to support both forms of password setting:

On xenial or earlier:

SET PASSWORD FOR 'nagios'@'localhost' = PASSWORD('new-password');

On bionic and later:

ALTER USER 'nagios'@'localhost' IDENTIFIED BY 'new-password';