| Re: MySQL's PASSWORD() function [message #174487 is a reply to message #174484] |
Tue, 14 June 2011 20:00   |
Luuk
Messages: 329
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 14-06-2011 20:41, qtrimble wrote:
> 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?
on the link it says:
The way in which the server generates password hashes for connected
clients is affected by the width of the Password column and by the
--old-passwords option. A 4.1 or later .....
which refers to:
http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_ol d-passwords
--
Luuk
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]