Re: Ubuntu MySQL install with Virtualmin - password problems with 16.04.4 server
From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Fri, 30 Mar 2018 12:07:38 +0100
Message-ID: <p9l5pq$j1j$2_at_dont-email.me>
>
> I don't think that this is correctly deduced. MySQL ships (for quite some
> time now) with the auth_socket plugin [1] enabled and uses it for the
> default "root_at_localhost" account. That means for connecting to MySQL as root
> you don't need any password - when you run the "mysql" command as user root.
>
> *I* think that Virtualmin just isn't aware of that. It asks for a password
> that is never needed.
>
>
> [1] https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html
>
Date: Fri, 30 Mar 2018 12:07:38 +0100
Message-ID: <p9l5pq$j1j$2_at_dont-email.me>
[Quoted] On 30/03/18 10:42, Axel Schwenke wrote:
> On 29.03.2018 22:02, J.O. Aho wrote:
>> On 03/29/18 20:09, Abandoned Trolley wrote: >> >>> I don't understand how it is that I can assign a root password as part >>> of the Virtualmin install, which Virtualmin then uses to administer the >>> database - but I cannot use that same password to log in, even at the >>> console. >> >> I would say bad design, the password is only for their front end and >> they leave the database without root password
>
> I don't think that this is correctly deduced. MySQL ships (for quite some
> time now) with the auth_socket plugin [1] enabled and uses it for the
> default "root_at_localhost" account. That means for connecting to MySQL as root
> you don't need any password - when you run the "mysql" command as user root.
>
> *I* think that Virtualmin just isn't aware of that. It asks for a password
> that is never needed.
>
>
> [1] https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html
>
[Quoted] On an ubuntu install in January:
vps1:~$ su -
Password:
vps1:~# mysql
[Quoted] ERROR 1045 (28000): Access denied for user 'root'_at_'localhost' (using
password: NO)
vps1:~#
So it appears you are 100% wrong?
-- Climate Change: Socialism wearing a lab coat.Received on Fri Mar 30 2018 - 13:07:38 CEST