You can use PHP to connect to a MySQL database running on a different server. That's the good news. The bad news is that you can't do it with Wix - it doesn't support PHP.
I suggest you bite the bullet and redevelop your site using something else. Take a look at these options