|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
I am setting up a web based administrator for my MySQL database. It is mostly complete minus one detail. I cannot find an effective way to verify a MySQL user password for access verification.
The script connects to the mysql database with the root as user and password, I need it to then check the username and password in the user table against the username and password provided by the user for login. I can retrieve the username fine with a query, but the encrypted password is seeming to be a problem. Any ideas would be appreciated....... |
|
#2
|
|||
|
|||
|
Nevermind.....problem solved
![]() |
|
#3
|
|||
|
|||
|
how did you solve the problem?
|
|
#4
|
|||
|
|||
|
Encrypted the password provided by the user and then compared against the encypted string extracted from the user table in MySQL. Simple, yet effective.
|
|
#5
|
|||
|
|||
|
how can i encrypt the password when id dont know the encryption mechanism ?
vijay |
|
#6
|
|||
|
|||
|
Run a MySql query to encrypt the password in MySql format............ie:
#encrypt input password $sth = $dbh->prepare( "SELECT PASSWORD('$yourinput')" ); if ( !defined $sth ) { &log_error; } $sth->execute; $encrypted=$sth->fetchrow(); ####$encrypted will now contain your password to compare against the MySql password entry... |
|
#7
|
|||
|
|||
|
I am new to pearl. Any idea how it can be done in php.
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages > Perl Programming > MySQL password verification |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|