Read the MySQL manual. There are some hints in there. I have not done the exercise myself, so can not further advise (except the obvious one: make backups first).
Just thought of one thing:
A thing I'm aware off is that somewhere in the 4.x series the password function has changed. Version 4.0.23a still has the old function. So you have to pay attention there (the hash is longer and might not fit in the allocated space) and copying the old passwords to the new db will not work (as the hash is different). There is a way to force the old method, but not sure how.
Last edited by Wim Sturkenboom; 07-25-2007 at 03:52 AM.