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>


[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

Original text of this message