Hi,

In Maxscale 2.2.2 getting users with native password from mysql backends does not work. As you can see here: https://github.com/mariadb-corporation/MaxScale/blob/2.2.2/server/modules/authenticator/MySQLAuth/dbusers.c new query for getting users (for Mysql > 5.7) is

SELECT u.user, u.host, d.db, u.select_priv, u.authentication_string

    FROM mysql.user AS u LEFT JOIN mysql.db AS d

    ON (u.user = d.user AND u.host = d.host) WHERE u.plugin = ''

    UNION

    SELECT u.user, u.host, t.db, u.select_priv, u.authentication_string

    FROM mysql.user AS u LEFT JOIN mysql.tables_priv AS t

    ON (u.user = t.user AND u.host = t.host) WHERE u.plugin = '';

This part is added (this was not in 2.1.x versions): WHERE u.plugin = ''

And in my user.plugin column all users have 'mysql_native_password' value, so maxscale does not get them and 'maxadmin show dbusers <service-name>' is always empty so my clients can't connect to DB through maxscale.