Those folks @ MySQL are definitely nuts, for changing password hashing, but they are not THAT crazy, after all. So, I am going to post it here, for my own sake and for the sake of those who may find it here and bless me for being so kind (heh). Fresh Blurbs Irakli Nadareishvili "There are only two things you need to be a great programmer: curiosity and kindness. comments powered by Disqus Copyright © Irakli Nadareishvili. Source
When you add a user, in MySQL 4.11 and newer, with a command like: \ GRANT ALL PRIVILEGES ON dbname.* TO [email protected] IDENTIFIED BY \'secretPassword\'; It will create password entry with new You thought you were screwed, did not you? :) Not entirely. All rights reserved. 2004-. Anyway, here it is: MySQL has changed password hashing mechanism starting from version 4.1 and if you are trying to use any "older client" (including PHP 4 or the pre-last MySQL http://dev.mysql.com/doc/mysql/en/old-client.html
Posted on: December 18, 2005 I ran into this problem more than enough times, during the last year and I am tired remembering the solution, each and every time.