MySQL option is only for v5.7 and today v8 and v9 exists with native_password authentication deprecated.
New update app to last versions of MySQL is required to connect with MySQL
What update is needed, exactly? Isn't this something that can be configured at MySQL client level?