maria-discuss team mailing list archive
Mailing list archive
Re: Why does local root need a password?
That’s different, I think. That’s for a mapping between system users and dB users.
What I’m proposing is specifically for root, to be able to log in as any DB user.
> On Mar 25, 2019, at 6:21 PM, Justin Swanhart <greenlion@xxxxxxxxx> wrote:
> MariaDB already supports authenticating as OS users such as root, when use by UNIX domain sockets for communications:
>> On Mar 25, 2019, at 6:07 PM, Felipe Gasper <felipe@xxxxxxxxxxxxxxxx> wrote:
>> I’ve submitted a proposal to the MySQL team to allow the system administrator, when logging in via a local socket that indicates reliably that the DB client is the superuser (e.g., SO_PEERCRED in Linux), to not need a password. As implemented, my suggestion allows root to log in as any user.
>> The rationale is that the system administrator can do anything on the server (including manual edits to the DB files) anyway; thus, every user already implicitly trusts that user with their data.
>> This will simplify DB administration on several levels, but most conspicuously because a lost DB admin password will no longer necessitate the awkward one-time-init-file recovery method.
>> Would MariaDB be interested in this proposal?
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help : https://help.launchpad.net/ListHelp