Hi, you may face an issue where your Wordpress domain is pointed somewhere else and you want to see the blog from some other location. I mean your wordpress is installed on some hosting and domain is not pointed there.
THis way when you call your wordpress by example: from yourdomains.com it do not loads, so you want to load it from example IP: http://67.78.89.91/~username/ it redirects it loads, but not properly and shows error and no articles.
So what we do? Edit MYSQL database of your blog. Use PHPMyAdmin for example.
1. Find table wp_options
2. Browse it
3. Find value "home" and "siteurl" and change it to http://67.78.89.91/~username/ or any other url you want.. (your ip, your account username, path)
Then You should be able to see that site/login from http://67.78.89.91/~username/ without redirects to yourdomains.com !