Moving WordPress/How to change a site URL: the dirty way through phpMyAdmin
If you haven't already moved your site/blog, update the URL through the WP dashboard this way: http://www.lobrc.net/2012/02/change-wordpress-url/
If you have, read on.
It's pretty simple actually.
1. Login to phpMyAdmin and select your database on the left
2. Click the 'SQL' tab at the top
3. Enter the following:
UPDATE wp_options SET option_value = 'http://www.new_domain.com' WHERE option_value = 'http://www.old_domain.com'
(replace new_domain and old_domain with your new and old domain. Take care to include the http:// and www)
4. Click Go
Moving WordPress/How to change a site URL: the proper way
Update: If you've already moved your site/blog and cant access the Dashboard, update your URL through phpMyAdmin. http://www.lobrc.net/2012/02/change-wordpress-url-phpmyadmin/
I see loads of posts on forums about people who move their WordPress blog to a different domain or URL, and then get a load of errors when trying to view their site, and let's be honest, we've all done it before! 
The reason this happens is because you're accessing your site/blog from a URL that WordPress doesn't recognise.
The solution is simple. Change the URL in your WordPress dashboard before you move your site.
Here's how:
1. Settings > General
2. Update your new URL
If I were to move this blog to lobrc.net/blog, then I'd change the WordPress Address field to http://www.lobrc.net/blog
(I'd leave the Site Address field as it is since my website homepage would still be www.lobrc.net. If you were moving your WordPress site to a whole new domain then you'd update this field too)
After you click save, you'll probably get an error or two when visiting your site. Don't worry. As soon as you've moved your site, you'll be up and running without any problems 
How to view/reset your WordPress password through phpMyAdmin/cPanel
In this post I'm going to show you how to view and reset your WordPress user password through phpMyAdmin.
What's phpMyAdmin, I hear you asking. From their site: "phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web." (Basically It's just an online tool to manage your MySQL databases).
So what do I do?
Login to your cPanel, and click that little 'phpMyAdmin' button.
Then, select your WordPress database on the left.
Select the users table, usually called wp_users.
First we're going to view the password. To do this, find the your username and check in the 'user_pass' column. You'll see a load of garbage. That's your password encrypted in MD5. For example purposes, let's say it's 5f4dcc3b5aa765d61d8327deb882cf99. We need to decrypt that. Any MD5 decrypter will work, but I'm going to use http://www.md5decrypter.com/. All you have to do is enter your encytped password and the CAPTCHA and BINGO!, you have your password in plain text.
You'll see that 5f4dcc3b5aa765d61d8327deb882cf99 = password
Now to change it. We're going to do exactly the same thing in phpMyAdmin, but this time click Edit.
Find user_pass:
And change it to look like this (where new-password is your new password):
Note how the function has been changed to MD5.
Click Go.
Now you should be able to login with your new password