Problem Modifying Userpasswords

[peterlaursen]

Quote:

here's the password hash

*9F6D2F236AEFE75CB25D1962C28230F5DCDEE60C

The hash SHOULD be:

69c4a4d359c7dd6b

The hashing method/algorith changed with MySQL 4.1. The first way is correct for 4.1 mysql and higher.

Quote:

it modifies soemthing but the new password doesn't work

With what client does it not work? Do you get any error messages (why will we always have to ask this question?) ?

does this help?

http://webyog.com/faq/23_58_en.html

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Are you sure that you did run the update scripts after upgrading? How did you upgrade? Did you just copy the /datadir?

[RobbieB82]

peterlaursen wrote on Jul 31 2006, 01:06 PM:

The hashing method/algorith changed with MySQL 4.1. The first way is correct for 4.1 mysql and higher.

With what client does it not work? Do you get any error messages (why will we always have to ask this question?)

does this help?

http://webyog.com/faq/23_58_en.html

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Are you sure that you did run the update scripts after upgrading? How did you upgrade? Did you just copy the /datadir?

(this post is takin me a while to type as I'm at work/multi tasking so I'm revising my answers along the way heh)

I am using sqlyog 5.15 on my server but I was trying to test the password with an older version of phpmyadmin and a CMS I am trying to install (Joomla) so that's mybad. I just downloaded the latest yog on this pc and it is indeed working fine.

phpmyadmin gives me the client error, joomla just says invalid password but that's probably just a user friendly error.

As per my upgrade method, yes unfortunately I was ill advised by some people in an IRC channel so I did copy the data folder. I hired someone to fix the data corruption and finish repair the install.

So, in retrospect I suppose everything is working properly, just that phpmyadmin (older version) and my CMS/Forums can't handle the new passwords.

Atleast I know the cause and I can start harrassing them to get with the program. In the meantime I'll just need to use old passwords.

Thanks.

[peterlaursen]

It will do no harm to run the 'mysql_fix_privilege_tables.sql' script! And I think you should in case that the people that you hired did not. You will get into big problems with SP's and VIEWS in particular if the grant tables has not been updated!

[Author]

Posts