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')
Paul DuBois, paul@stripped