FUDforum: comp.lang.php » MySQL's PASSWORD() function

Home » Imported messages » comp.lang.php » MySQL's PASSWORD() function

Show: Today's Messages :: Polls :: Message Navigator

Re: MySQL's PASSWORD() function [message #174484 is a reply to message #174482]

Tue, 14 June 2011 18:41

qtrimble
Messages: 2
Registered: June 2011

Karma:

Junior Member

On Jun 14, 2:13 pm, Luuk <L...@invalid.lan> wrote:
> On 14-06-2011 20:03, qtrimble wrote:
>
>> I'm using WAMPSERVER for my development environment (MySQL v 5.1.553,
>> PHP v 5.3.4) . The software that I am modifying uses the MySQL
>> PASSWORD() function which works fine locally. After moving the code
>> and database to the production server (MySQL v 5.0.77, PHP v 5.3.3) I
>> cannot log in.
>
>> Is there anything other than the versions that could cause this
>> behavior? I was thinking maybe PHP extensions but I do not know what
>> the PASSWORD() function depends on.
>
> Something changed about storing passwords in MySQL between version 4.x
> and 5.0
>
> A compatibility switch was introduced in 5.0
>
> I think it no longer exists in 5.1
>
> All info is here:http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html
>
> If you have access to both systems check the output of:
> SELECT PASSWORD('something');
>
> and see if the output on both systems is the same,...
>
> --
> Luuk

The documentation states that prior to MySQL 4.1, password hashes
computed by the PASSWORD() function are 16 bytes long which is what
the result is when I tried your suggestion (SELECT
PASSWORD('something')) on my production server but my production
server MySQL version is 5.0.77. My development server is returning 41
byte. I also never did an upgrade which the documentation suggests
upgrading to 4.1 and then to 5 or higher. I installed 5.0.77
directly. This seems strange to me...any suggestions?

Report message to a moderator

[Message index]

		MySQL's PASSWORD() function By: qtrimble on Tue, 14 June 2011 18:03
		Re: MySQL's PASSWORD() function By: Luuk on Tue, 14 June 2011 18:13
		Re: MySQL's PASSWORD() function By: qtrimble on Tue, 14 June 2011 18:41
		Re: MySQL's PASSWORD() function By: Jerry Stuckle on Tue, 14 June 2011 19:55
		Re: MySQL's PASSWORD() function By: Luuk on Tue, 14 June 2011 20:00
		Re: MySQL's PASSWORD() function By: alvaro.NOSPAMTHANX on Wed, 15 June 2011 09:26

Previous Topic:	Brilliance requested - calculating a date next month
Next Topic:	check user log and redirect

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 16:40:25 GMT 2024

Total time taken to generate the page: 0.04172 seconds