Operator sets mysql_native_password=true when ProxySQL is enabled

[shcherbak]

Report

Operator sets mysql_native_password=true when ProxySQL is enabled because of using ProxySQL 2.5. The release 2.7 has support for caching_sha2_password

More about the problem

https://proxysql.com/documentation/authentication-methods/
https://www.percona.com/blog/caching_sha2_password-support-for-proxysql-is-finally-available/

Steps to reproduce

1. install pxc with proxysql
2. add user with crd

Versions

1. Kubernetes 1.31.2
2. Operator 1.16.1
3. Database pxc 8.0.39

Anything else?

No response