Thread: password encryption

Hello,

I want to encrypt passwords with Postgresql the way mySQL does it with :

UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';

How can I do that ?

Thanks a lot,

Laurent

On Fri, 21 Jul 2000, Silesky Marketing Inc, Support wrote:

> Hello,
>
> I want to encrypt passwords with Postgresql the way mySQL does it with :
>
> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';

Check out the ALTER command.

ALTER USER username
    [ WITH PASSWORD 'password' ]
    [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
    [ VALID UNTIL 'abstime' ]


Rod
--
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814

I think what he was looking for was more along the lines of a generic sql
function that hashes a string, and not to update the system tables.

I actually wrote a replacement for the mysql PASSWORD() function that is
actually compatible with the hashing that mysql uses.  If you would like a
copy of this function just let me know so I can extract it out of the a
bunch of other functions.

Aaron
On Fri, 21 Jul 2000, Roderick A. Anderson wrote:

> On Fri, 21 Jul 2000, Silesky Marketing Inc, Support wrote:
> 
> > Hello,
> > 
> > I want to encrypt passwords with Postgresql the way mySQL does it with :
> > 
> > UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
> 
> Check out the ALTER command.
> 
> ALTER USER username
>     [ WITH PASSWORD 'password' ]
>     [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
>     [ VALID UNTIL 'abstime' ]
> 
> 
> Rod
> --
> Roderick A. Anderson
> raanders@altoplanos.net               Altoplanos Information Systems, Inc.
> Voice: 208.765.6149                            212 S. 11th Street, Suite 5
> FAX: 208.664.5299                                  Coeur d'Alene, ID 83814
> 
> 
>