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
Is it possible to do the same with MySQL?