MySQL MD5() Problem

[edwa5823]

I seem to have a problem getting MySQL to compare strings correctly using the MySQL MD5() function. Here is an example:

I have a table 'users' with two fields (among others) 'username' and 'password'. In this example the username is 'tester' and the password is '098f6bcd4621d373cade4e832627b4f6' (test).

This code fails:

Code: Select all

SELECT * FROM users WHERE username='test' AND password=MD5('test');

This code succeeds:

Code: Select all

SELECT * FROM users WHERE username='test' AND password='098f6bcd4621d373cade4e832627b4f6';

I have tried this every which way and two hours later it I have to assume that this is a XAMPP issue. If anyone has any insight PLEASE let me know.

Thanks in advance.

[logout]

The Query sees the "MD5('test')" as the password and not the md5-Encryptet string.

Try this:

Code: Select all

$sql = "SELECT * FROM `users` WHERE `username` = 'test' AND `password` = '".md5('test')."'";
$result = mysql_query($sql);


Now it has to work.

[edwa5823]

I am sure that will work, it would be using the php MD5() function to encrypt the password. The point that I am making is that MySQL has an embedded function MD5() that will encrypt it when mysql runs. It works just fine on my actual live Apache server but the Xampp installation fails. I just found it odd since it is running the same software in essence.

[pt]

I have the same problem between different xampp versions.

I have inserted the SQL datas from one database to another of a different pc. Surprise, the password was invalid.

I suspect the cause is the SQL codes/character sets (a.e. UTF-8 Unicode)...