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 #174482 is a reply to message #174481]

Tue, 14 June 2011 18:13

Luuk
Messages: 329
Registered: September 2010

Karma:

Senior Member

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

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: Sun Nov 24 15:28:57 GMT 2024

Total time taken to generate the page: 0.04798 seconds