It appears that passing RAND() with no arguments to the pw_passwd field
breaks mysql replication.
> Hello Ken,
>
> On Friday, October 11, 2002 at 1:32:14 AM you wrote:
>
> > You can use the MySQL crypt command. It calls the unix crypt()
> > function, so it's compatiable with vpopmail (and /etc/shadow)
>
> One addition, to make it more md5-like:
>
>
ENCRYPT("<PASSWORD>",CONCAT("$1$",SUBSTRING(MD5("<PASSWORD>"),ROUND(RAND()*1
0),5),"0"))
>
> with '<PASSWORD>' being the actual password should do the job.
>
> HTH
> Pit
> --
> Best regards
> Peter Palmreuther mailto:lists@;pitpalme.de
>
>
>
