MySQL Forums
Forum List  »  Security

password function returning different values
Posted by: roseymysql.20.ftumsh
Date: September 28, 2006 09:10AM

Lo all,

mysql 4.1.13 standard log on Red Hat Enterprise Linux ES release 3 (Taroon Update 5)
It's a standard rpm download binary.

I have two servers, TEST(port 3308) and LIVE (port 3307).

When I connect to TEST and do:
select password('a');

I get:
60671c896665c3fa

When I connect to LIVE and do:
select password('a');

I get:
*667F407DE7C6AD07358FA38DAED7828A72014B4E

Both connections are on the RH box using the same client. Settings in my.cnf are identical. The old_password switch isn't in use.

Why the difference?

Thx

John

Options: ReplyQuote


Subject
Views
Written By
Posted
password function returning different values
5864
September 28, 2006 09:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.