Bug #49940 Authenticate by Linux system account
Submitted: 26 Dec 2009 11:38 Modified: 11 May 2011 14:43
Reporter: Olaf van der Spek (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:* OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[26 Dec 2009 11:38] Olaf van der Spek 
Description:
Could you add an option where the MySQL server does authentication by the Linux system account of the other end of the (local) connection?

This will only work for local connections, but is very handy. Passwords would no longer be needed, making it both more secure and easier.

In addition to user name/password, the privilege tables should contain a unix_account column.

How to repeat:
-
[26 Dec 2009 14:47] Valeriy Kravchuk 
Thank you for the feature request.
[11 May 2011 14:44] Dmitry Lenev 
Hello!

In 5.5.10 version of MySQL server auth_socket authentication plug-in has been added, which addresses this feature request. See http://dev.mysql.com/doc/refman/5.5/en/socket-authentication-plugin.html for more information.

Therefore I am changing status of this feature request to Closed/Implemented.