MySQL OLD_PASSWORD Issue
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');
Recent Comments
Jef wrote:
haha. I had just begun my...
Rob White wrote:
I need to post mine. My...
Chinese translation wrote:
This is great, I was looking...