If you swap a MySQL 8.4 volume to 9.7, accounts using mysql_native_password will no longer ...

MySQL 9.7 is the next LTS after 8.4, and the official stance supports the path from 8.4 LTS to 9.7 LTS. Meanwhile, ...