maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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@xxxxxxxxxxx

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)
> ```