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

From: J.O. Aho <user_at_example.net>
Date: Sun, 1 Apr 2018 08:41:16 +0200
Message-ID: <fibd8cFc49pU1_at_mid.individual.net>

On 03/31/18 19:17, Thomas 'PointedEars' Lahn wrote:
> J.O. Aho wrote:
>

>> On 03/31/18 01:37, Thomas 'PointedEars' Lahn wrote:
>>> 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.
>>>
>>> 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.
>>
>> Not talking about as whom the web server is run as, but how the so
>> called database root user password is used, as the password set during
>> installation isn't used hasn't been set for the mysql database user
>> root, it's only used as password to access the database through the web
>> ui. Please don't assume things, read instead what people has written.

>
> Likewise. And shut up when you don’t have a minimum clue.
>
> Contrary to what Axel said:
>
> On my Debian/Devuan GNU+Linux system, with a *default* MySQL configuration,
> it is not possible to connect to the MySQL server as MySQL user “root”
> without a password when the “mysql” command is run as system user “root”:

Don't know what you have been smoking, this is what has been said about logging in:

On 03/29/18 20:09, Abandoned Trolley wrote:

> I am able to get in to mysql by simply using "mysql --user=root" as
> superuser on the machine console - so there is not problem getting
> access to the database.

As you see he connects to the database without password.

> 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.

He is wondering why he did provide a password during Virtualmin installation for the database user root.

so thanks again for not reading.

-- 

 //Aho

Received on Sun Apr 01 2018 - 08:41:16 CEST