[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.

[Author]

Posts