>>2. Is it possible to let the users by them self change their
>>password? Then they could change it to their UNIX-password. As far
>>as I know only the MySQL admin can change the users passwords. :(
>
>Yes, that's possible. The user connects and issues this command:
>SET PASSWORD = PASSWORD('new password')
Thanks it worked!
The only way I can think of how to manage the transfer of the UNIX accounts
into MySQL is to give all users a temporary password (unique for each user)
and then ask them to change it to their UNIX account password imediately.
To avoid sending the temporary passwords by mail one could put it in a file,
e.g. "mysql_temp_pw.txt" (with perms 600) in their homedir. Then one could
delete that file after they have changed the pw.
I know there is security problems if you have the fs over NFS, but I think
it is better than sending the pws by mail.
/jonap
_________________________________________________________________
Hämta MSN Explorer kostnadsfritt på http://explorer.msn.se
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
