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');

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.

Here is a quick an easy way to select random rows in SQL Server 2005:

SELECT
     ColumnA, ColumnB
FROM
     dbo.[TableName]
ORDER BY
     NEWID()