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

docker-library / ghost

Docker Official Image packaging for Ghost

https://hub.docker.com/_/ghost

MIT License

720 stars 311 forks source link

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

Open simonmcnair opened 4 months ago

simonmcnair commented 4 months ago

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 commented 4 months ago

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).