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.

-FG

> On Mar 25, 2019, at 6:21 PM, Justin Swanhart <[email protected]> wrote:
> 
> MariaDB already supports authenticating as OS users such as root, when use by 
> UNIX domain sockets for communications:
> https://mariadb.com/kb/en/library/authentication-plugin-unix-socket/
> 
>> On Mar 25, 2019, at 6:07 PM, Felipe Gasper <[email protected]> wrote:
>> 
>> Hello,
>> 
>>    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?
>> 
>> -FG
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : [email protected]
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to