List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 13 2006 5:23pm
Subject:Re: Using posix users
View as plain text  
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
Thread
Using posix usersYannick Gingras13 Oct
  • Re: Using posix usersDan Nelson13 Oct
    • Re: Using posix usersYannick Gingras13 Oct