Page 1 of 1

Secure MySQL Access md5()

Posted: Thu May 13, 2004 4:00 pm
by rxsid
Hi all,

I've got:

WinNT
php 4.3.1
phpmyadmin 2.5.6
MySQL 4.0.18-nt

I can connect to my db via my php script using:

Code: Select all

$connection = mysql_connect ("localhost", "root", "")
That works no problem.

This will not work however:

Code: Select all

$somePass = md5("somePass"); 
$connection = mysql_connect ("localhost", "someID", $somePass)
gives me:


Access denied for user: 'someID@localhost' (Using password: YES)

I set someID up in the db using phpmyadmin, with it's password using the md5() function. I can see via phpmyadmin that someID does indeed have a 32 byte encrypted password stored.

I can then compare the stored md5 password to the md5 password I'm passing to try to connect...via $somePass. The encrypted passwords match exactly.

Why wouldn't the match be confirmed...allowing me to connect?

Thanks!

Posted: Fri May 14, 2004 6:55 am
by kettle_drum
Try:

Code: Select all

$connection = mysql_connect ("localhost", "someID", "32charmd5passwordvalue")
The error message is because the pass is wrong, so you jsut need to try different methods of inserting the pass. Make sure theres no whitespace.