At 8:27 AM +0000 9/17/01, Jonas Larsson wrote:
>> > But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX? Why
>>> isn't that implemented? Then it would be easy to transfer the hash...
>>>
>>
>>Yes it definitly would be nice and would have been easier to impliment than
>>the current Password() implimentation (just call crypt()!!). I found that
>>Postgresql uses the built in system crypt() while Mysql uses its own hash
>>which causes some problems when porting a database between the systems.
>
>1. Have you find a way of porting the pw-database from UNIX to
>MySQL? As I see it it is impossible due to the one-way-hash of MD5.
>The only way I've found out is to give all users a new password. :(
>
>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')
>
>/jonap
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
