Re: Ubuntu MySQL install with Virtualmin - password problems with 16.04.4 server

On 03/30/18 13:34, The Natural Philosopher wrote:

> mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS
>     ->        FROM INFORMATION_SCHEMA.PLUGINS
>     ->        WHERE PLUGIN_NAME LIKE '%socket%';
>
> Empty set (0.10 sec)
>
> Which demonstrates at least on Ubuntu that "the auth_socket plugin [1]
> enabled and uses it for the default "root_at_localhost" account" is a false
> statement.

Looking through the oracles mysql installer, it don't seem to add the auth_socket plugin, it just provides the .so file and you have to manually enable it is you want to use it.

-- 

 //Aho