From: Martijn Tonies
Date: April 9 2008 11:57am
Subject: Re: We have just moved to a new web server where wearerunningmysql version:  5.0.45
List-Archive: http://lists.mysql.com/mysql/212172
Message-Id: <017801c89a38$d6fa19a0$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>Thanks for the email but that didn't help.  I gave the commands again using
only single quotes and I still get no results.
>On the old machine we were running MySQL 4.0.15a.  Is there any difference
with the password function in these 2 versions?

Could be, I remember MySQL 4.1 having a new password mechanism. If this uses
the same function, I guess you shouldn't be surprised it returns a very
different value
in 4.1 and up.

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com