mysql version 8.4 - ''mysql_native_password' is deprecated and will be removed in a future release

[simonmcnair]

I found ghost wouldn't start due to this error:
I ended up fixing it short term with the following change for the mysql db service:

command: --mysql-native-password=ON

2024-05-07T10:28:37.982534Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

I don't know if there is a long term view to changing password authentication.

[tianon]

I think this needs to be filed at https://github.com/TryGhost/Ghost/issues?q= instead (since this is something that needs to be updated in Ghost upstream, not something we'd be able to update in our packaging).