Losing a temporary URL. Error 404

Hi All,

I am switching servers and now they are switched, I am on a temporary URL:

https://109.203.108.152/~hypnothe/www.musicproductioncourses.net/

I need to lose everything up to the www. I’m not sure how to do that in the database. If you paste: https://www.musicproductioncourses.net/ into your browser, it works fine but when you try and browse to a page, you get the ‘https://109.203.108.152/~hypnothe/’ before the right URL and a blank page with error 404.

I can’t change the WordPress address or site address in general settings: https://screencast.com/t/mUgdksy4DUW

I thought you could do that and it would sort out my problems if I did.

Sorry, I’m not quite a novice but not too far away from that!

Thanks in advance

Dave