From: Dan Nelson
Date: October 13 2006 5:23pm
Subject: Re: Using posix users
List-Archive: http://lists.mysql.com/mysql/202604
Message-Id: <20061013172350.GB2226@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Oct 13), Yannick Gingras said:
>   I have a computer lab where students learn bioinformatics.  The
> courses include a crash course on database and we want to use MySQL
> since it is a popular engine for bioinformatics.
> 
> No one like to remember multiple passwords and since want each
> student to have its own MySQL user and database I wanted to make a
> mapping between the database users and the posix users. 
> Unfortunately I can't find how to do that.
> 
> Let's to be a bit more explicit on what I want to do, I would like
> the user foo in MySQL to be authenticated though pam on the posix
> user foo.  That way if foo changes his password with passwd, he will
> automatically change his MySQL password.  This is what happens with
> Postgresql with the shell command
> 
>   createuser foo
> 
> Is it possible to do the same with MySQL?

Not yet, but it being looked at:

http://bugs.mysql.com/bug.php?id=4703
http://forge.mysql.com/wiki/PluggableAuthenticationSupport

-- 
	Dan Nelson
	dnelson@stripped