Several months ago I had problem on upgrading CPanel’s MySQL 4.1 to MySQL 5. The problem was occurred on Centos 5 OpenVZ based VPS. Since someone contact me at WebHostingTalk forum asking about the same problem so I decided to re-try again the steps to fix the problem. Hence I post it here too, for future and general purposes :)
ok, do this at your own risk :) backup your mysql data first!
the steps i do: