Password() generates random result in 4.1.0 alpha

"Kevin Lee" <[email protected]> Wed, 13 Aug 2003 01:08:15 +0800

Newsgroups	gmane.comp.db.mysql.bugs
Message-ID	<002a01c360f4$524d9a10$0200a8c0@NOTEBOOK>

Hello,

In 4.1.0 alpha, I found the result of "SELECT PASSWORD('WHATEVER')" statement is generating random results. Therefore I had to use MD5() to store password to my tables.

This problem does not exists in 4.0, where PASSWORD() gives consistent result.

Why can this happen?

lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.