Many PHP developers out there are probably aware of the change in MySQL’s password hashing algorithm changes between version MySQL 4 and MySQL 5. It requires you to update User passwords when upgrading your database version. The syntax for how to do this is below. However, I just ran into a situation while doing maintenance on a web environment that required me to switch database servers and move and existing MySQL version 4.1.21-community-nt to 4.1.22-community-nt. Much to my surprise, this password hash change existing in MySQL 4.x even between minor releases.

SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('original-password');

Its Spring time so I thought it would be a good idea to ring in the season by refreshing the colors on www.brianjeremy.com. In addition, I went out with the Ice Cream Man yesterday for lunch and got my first viewing of the new Toyota Yaris. Keep your eyes open for that Popsicle driving around town.

Tonight is the TechCrunch Geek Goes Chic party tonight with PopSugar at the Vanguard in Hollywood. I was fortunate enough make it on the limited list of the gathering where one of the largest fashion, beauty, shopping and celebrity news blogs commingles with technology folks that put these startups together.  I’ll make sure to report back on the outcome of the event.

Well, the time has come. Its been a year and a half in the making… Please register for the private beta testing of Zigabid.com. For the promotion code enter “BJK” and you’ll get priority selection.