I am from India. My website which is hosted by Yahoo is getting designed by a designer these days. He's using WP Comfy theme. I am including forums in it. My designer says that Yahoo only supports mySQL version 4.1 which will not support all features of the forum that I am desiring. Now how to solve this problem?
Find a new host. It's not going to be feasible to hack in forward updates into outdated software. MySQL 5 has been out for several years. If they can't provide you the option of 4, or 5, or 5.5 which was recently releases, I would search for a new host.