Re: Ubuntu MySQL install with Virtualmin - password problems with 16.04.4 server
From: Thomas 'PointedEars' Lahn <PointedEars_at_web.de>
Date: Sat, 31 Mar 2018 01:37:41 +0200
Message-ID: <3749235.1IzOArtZ34_at_PointedEars.de>
>
> 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.
Date: Sat, 31 Mar 2018 01:37:41 +0200
Message-ID: <3749235.1IzOArtZ34_at_PointedEars.de>
[Quoted] Axel Schwenke wrote:
> On 29.03.2018 22:02, J.O. Aho wrote:
>> 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.
[Quoted] You are both writing nonsense. Virtualmin is “a powerful and flexible web hosting control panel for Linux and BSD systems”. *No* secure Web server runs as “root” by default (and none should); usually it is “www-data” instead.
-- PointedEars Zend Certified PHP Engineer <http://www.zend.com/en/yellow-pages/ZEND024953> <https://github.com/PointedEars> | <http://PointedEars.de/wsvn> Twitter: _at_PointedEars2 | Please do not cc me./Bitte keine Kopien per E-Mail.Received on Sat Mar 31 2018 - 01:37:41 CEST