Admin password ok in local but not on server

emtor

I've downloaded a php/mysql-webshop and it works like a charm on localhost.
Today I set up the exact same scripts and imported the identical database on a remote server, and now the admin login script refuses to accept the user/password.
Strange . . . since user/pass works locally on my laptop.
NOTE: I'm NOT talking about accessing the remote database, but simply logging in to the webshop's admin pages. The config file is updated with the correct host/user/password for the remote server. Also the encrypted passwords in my local database and that of the remote database are equal. Still I can't log on to the remote adminpages.

I do not get the typical error-message you'd normally get when a script attempts to log on to mysql with the wrong host/user/password. Instead I get an error message that seems to be generated by the webshop's login script.
It seems to me that the login-script successfully accesses the users-table of the database and fetches the encrypted password, but somehow finds that it is different from the password just typed in (even if they are not).

I run MySQL version: 3.23.49 locally, and version 5.0.51a on the remote server.
Could it be that these two mysql-versions treat the encrypted passwords differently?

emtor

I have a login script that works fine on localhost, but on a remote server it won't recognize an otherwise working password.
Scripts and databases are identical both locally and remotely, and the encrypted password entries are also identical.
Locally I run mysql 3.23.49. The remote server runs mysql 5.0.67

Do these mysql-versions treat encrypted passwords differently?

dp777

In a past experience with a similar problem, the issue was exactly what you described, different encryption. There is some goofiness in the way newer MySQL and PHP deal with those things in the newer versions of MySQL. On your MySQL 5x box, go back and recreate the passwords wrapping them in the OLD_PASSWORD() function. Google MySQL OLD_PASSWORD for any extra details you may want.

HTH!

emtor

I suspected version issues all along, but thanks for confirming it.
I'll log in to the control panel on my remote server and see if I can push some buttons 🙂

emtor

RESOLVED
I solved the problem by performing a sql-query to the database in phpMyAdmin where I inserted a md5 password hash into the user table. Then I changed the hashing-algorithm in the login-script from mysql's PASSWORD function to md5 function. Now it works.