Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #2176

Re: MySQL's PASSWORD() function

Show all headers | View raw

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_old-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
--

Back to comp.lang.php | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

MySQL's PASSWORD() function qtrimble <qtrimble@gmail.com> - 2011-06-14 11:03 -0700
  Re: MySQL's PASSWORD() function Luuk <Luuk@invalid.lan> - 2011-06-14 20:13 +0200
    Re: MySQL's PASSWORD() function qtrimble <qtrimble@gmail.com> - 2011-06-14 11:41 -0700
      Re: MySQL's PASSWORD() function Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-14 15:55 -0400
      Re: MySQL's PASSWORD() function Luuk <Luuk@invalid.lan> - 2011-06-14 22:00 +0200
  Re: MySQL's PASSWORD() function "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid> - 2011-06-15 11:26 +0200

csiph-web