Jump to content

phpMyAdmin using PASSWORD function


ITStudent

Recommended Posts

I created a login in page that compares the entered password to the password stored in the MYSQL database. The password stored in the database is encrypted using the PASSWORD function, so I encrypt the entered password with the PASSWORD function and compare with that in the database. Everything works fine on my own server, which I used to test the scripts. However, on hosting company it will not work. The problem is with the PASSWORD function.

I use mysql ver 5.0.15-nt with phpMyAdmin 2.6.4-pl3
Hosting company uses mysql ver 4.1.19-standard with phpMyAdmin 2.8.0.2

Anyone any ideas what could be wrong? (It works if I don't encrypt the password)

Thanks.
Link to comment
Share on other sites

MD5() or SHA1() are fine hashing algorithms.

As fenway alluded to, you're not supposed to use the MySQL PASSWORD() function for your own schemes, just inputting actual MySQL access passwords.  I think they changed its underlying scheme at some point, perhaps between the differing versions you and your ISP have, and that's pretty much [i]why[/i] you're not supposed to use it.  They reserve the right to change it at any time.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.