Hi, William, Don't use mysql.user. It's only preserved for compatibility with old application and intentionally does not support any new authentication features. You can see all plugins in `show create user`. The actual table where this information is stored is mysql.global_priv https://mariadb.org/authentication-in-mariadb-10-4/ Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org On Oct 13, William Edwards wrote:
Hi,
When creating an account with multiple authentication plugins, in this case 'unix_socket' OR 'mysql_native_password', the mysql.user.plugin column is set to either one.
How should I retrieve *all* used authentication plugins for a given user?
Example:
``` MariaDB [(none)]> CREATE USER 'testing'@'localhost' IDENTIFIED VIA unix_socket OR mysql_native_password USING 'invalid'; Query OK, 0 rows affected (0.005 sec)
MariaDB [(none)]> select user,host,password,authentication_string,plugin from mysql.user where User = 'testing'; +---------+-----------+----------+-----------------------+-----------------------+ | User | Host | Password | authentication_string | plugin | +---------+-----------+----------+-----------------------+-----------------------+ | testing | localhost | invalid | invalid | mysql_native_password | +---------+-----------+----------+-----------------------+-----------------------+ 1 row in set (0.003 sec) ```