List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 17 2001 1:52pm
Subject:Re: Sharing pws between UNIX and MySQL?
View as plain text  
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, paul@stripped
Thread
Sharing pws between UNIX and MySQL?Jonas Larsson16 Sep
  • Re: Sharing pws between UNIX and MySQL?Paul DuBois16 Sep
Re: Sharing pws between UNIX and MySQL?Jonas Larsson17 Sep
  • Re: Sharing pws between UNIX and MySQL?ryc17 Sep
Re: Sharing pws between UNIX and MySQL?Jonas Larsson17 Sep
  • Re: Sharing pws between UNIX and MySQL?Paul DuBois17 Sep
Re: Sharing pws between UNIX and MySQL?Jonas Larsson17 Sep