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

Wed, 15 June 2011 09:26

alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010

Karma:

Senior Member

El 14/06/2011 20:03, qtrimble escribió/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.

I suppose you are talking about your application users, not MySQL users.

You can use OLD_PASSWORD() if you need to emulate the old format in a
new system:

http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_o ld-password

SELECT PASSWORD('abcd'), OLD_PASSWORD('abcd')

*A154C52565E9E7F94BFC08A1FE702624ED8EFFDA 2e64a4f078c68549

--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

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: Tue Nov 26 11:40:14 GMT 2024

Total time taken to generate the page: 0.05922 seconds