First off you will need to make backups...
Have you got them ?
Then all you do is login to your vps, upload the backups and change the config.php to your new database username

If you still can't get it, let me know & i will do a step by step guide