Mysql password hashing on mysql 5 - osx

mysql update problem with passwords

[stevenjm]

Hi,
am having trouble with getting mysql 5 for osx to recognise passwords from previous version 4.

Seems to use a different password hashing than ver 4.

Any help much appreciated.

[whoisgregg]

You'll want to use the OLD_PASSWORD() function... There's a comment on the Mac OS X installation page [dev.mysql.com] with an example.

A search for "mac os x mysql OLD_PASSWORD [google.com]" in your favorite search engine will provide more details. :)

[stevenjm]

Thanks heaps for that. I had already tried that but maybe I missed something. :)

[stevenjm]

Sorry, I should have been more specific. I had used that command for root with success however databases are now having password problems.

Does this mean I now have to somehow apply that to all database passes as well?

have about 50 databases and none are connecting.

[whoisgregg]

Basically, you need to go into your user authentication table and just set the passwords again. You can set them to the exact same password and, now that you are using MySQL 5, they'll be setting using the new, longer encryption hashes. Then everything will work without any need to worry about OLD_PASSWORD nonsense.

Here are lots of details [dev.mysql.com] if you'd like to know more. (This document [dev.mysql.com] might also apply.)

[hanglide]

Had the same problem (but I was using Vista). It wasn't an OS issue -in my case. I had to use old_password() instead of password() to pass the password.

[webmasterworld.com...]

Hope this saves you the headaches I had :-)

Scott

[stevenjm]

Thanks heaps guys. This has been annoying me for a while and could get root sorted out but not the others.