MySQL 8.0 changed the default to caching_sha2_password, which seems to
be unrecognised by various clients, causing authentication failures with
both the `mysql` CLI and through PHP's MySQL modules.