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';
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';