Hello, has anyone attempted to upgrade their MySQL4.x to MySQL5.x? I have a few websites on my server which runs Apache2.2, PHP5 and MySQL4.1 and I need to upgrade/install MySQL5.0, will I encounter any problems, anyone here that can share experience with this? 
I'm thinking I would need to deinstall the 4.1 and then install 5.0, will the data (users ,passwords, databases) be kept intact?
Thanks!

I'm thinking I would need to deinstall the 4.1 and then install 5.0, will the data (users ,passwords, databases) be kept intact?
Thanks!