The easiest way to handling this is, you can do a signup for a new end user account under your reseller account and create database there, that new account will automatically get MySQL database version 5.0 .Then you can use new database for your existing user website instead of old database which is having MySQL version 4.0.27.