Knowledgebase: Support
Admin password and/or login do not work anymore
Posted by Lena Kosyakova on 15 February 2010 03:09 PM
This may happen in case your hosting has changed the version of their MySQL server; the older versions use OLD_PASSWORD() function for keeping passwords, and newest versions (> v. 4.1) use PASSWORD() function.

Please refer to the following articles:
http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_old-password
http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_password

You can enter your PHPmyAdmin console and run the following command to change admin's login and password (or ask your server administrator to do this):
UPDATE `administrator` SET `username` = 'a_desired_login', `password`=PASSWORD('a_desired_password');

(189 votes)
This article was helpful
This article was not helpful

Comments (0)
Post a new comment 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Help Desk Software by Kayako Fusion