also sprach LINUXQNA:
>
> How can I get the 'pw_passwd" column.
> I want to change the pw_passwd on the web directly SQL query...
>
> What kind of hash function or encrypt method
> is used?
The pw_passwd field is generated using standard crypt(). You can change it
with something like:
UPDATE example_com
SET pw_passwd = ENCRYPT('plaintext')
WHERE pw_name = 'some_username';
Assuming you want to change the password for user
<[EMAIL PROTECTED]> to be ``plaintext''. (And assuming you are using
large domain support, and so on. But you should get the point.)
/pg
--
Peter Green : Gospel Communications Network, SysAdmin : [EMAIL PROTECTED]
---
A Linux machine! because a 486 is a terrible thing to waste!
(By [EMAIL PROTECTED], Joe Sloan)
