When i asked my host if i could recover the password for the previous database, here was the answer:

"There is no way to recover these passwords. You need to delete the database user and then re-add it."

I kind of guessed that but wanted to make sure. Now, if i delete the database user and re-add it (with a known password) how will this affect my LIVE store??