I'm on a debian9 an use MariaDB 10.1.38 on a remote host. Infront of the db-hosts is a MaxScale Proxy 2.2.20 In VM I set Password storage mode = Only store hashed passwords.
Now when I create a new "Virtual Server" VM put the passwort in the "authentication_string" field. But in MariaDB the "password" field is still present unlike in MySQL > 5.7 (I guess). Now the MaxSale uses the "password" field to authenticate users.
Is it possible to force VM to use the "password" field instead of "authentication_string" or even set it in both?