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 secur...@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) > ``` _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
