Changed WordPress Blog Address in Settings–Locked Out? How to Fix!
See the video below for step-by-step directions for “fixing” this problem through phpMyAdmin. If you don’t have access to phpMyAdmin, or are hesitant about messing with the database, see the video in this post for directions on how to “patch” your config.php file to regain access until you can get someone to help you fix the problem in the database.
Related posts:
- Resetting Your WordPress Password Tweet Note: The following is made available under GPL from...
- iNove 1.4.5 Theme for WordPress– How to Increase the Header Size Tweet In older versions of the iNove theme, increasing the...
- Easy 5-Step WordPress Install Tweet Note: The following is made available under GPL from...
- Common WordPress Installation Problems — And How to Fix Them! Tweet Note: The following is made available under GPL from...
- How to Create a Mobile WordPress Site Tweet If you don’t currently have your WordPress blog configured...

thanks a lot … you saved me a lot if time and pain
thanks once again
hi,
thanks for the great tutorial. really you saved a lot of time to reinstall worpress and configure it!
thanks!
regars,
sanjee
Great you save my evening
THANK YOU! I am adding this site to favorites. Excellent content.
Thanks for that, I didn’t even know I had phpMyAdmin on cpanel.
Cheers
Sean
Excellent. I did do this and as it was the early stages i set up a new one.
Good work.
Sincere thanks for this vid. Fantastic
Thank you for this post! You saved me hours of time and banging my head against the table,wall,etc! Thanks again.
YOU just SAVED my mental (and physical probably) health! I am also having server issues – which is how this happened (was on the phone and clicking around like an idjit – so the URL was actually trying to go to my Post Office Box LOL – I can laugh now!)… so this has been a mind-bending day.
Still having server issues – may change servers (99% chance)
THANK YOU SO MUCH!
@Linda: You’re welcome…glad it helped.
Thanks for saving my day.
Lifesaver!
man – your tutorial is so helpful. thanks so much. I was toiling around in all the wrong places. now I just need to figure out how to actually move things so I CAN change the wordpress address. ideas?
Fantastic! Thanks a lot!
@Arjan: Just look at the “Move” category here…there are several tutorials on moving WordPress and changing the address.
Thank you sooooooo sosososososossosooo muchhh!!!!
Thank you! I almost had a heart attack when I broke the blog!
I just want to thank you for this very well done video in how to fix this simple yet problematic issue on wordpress. you basically saved me lots of time. yeah yeah… you actually “saved my life”.
greetings from Sahara Desert.
Thank you very much. My jaw is no longer on the floor and my mind is at ease. I was figuring I’d be browsing Google for hours looking for a fix and I went from crash to back up and running in 20 minutes. You rock!
how do i login to cPanel?? please help
@AJ: That will depend on whether your host offers Cpanel. You will need to contact them and ask.
Two words, THANK YOU!!
Panic over, thanks alot for posting this.
Mike
Excellent post, thank you for the great tutorial.
George
You are a life saver!! After weeks of setting this up, I did it, I changed the path!
This tutorial was great! It showed me exactly how to fix it and IT WORKED!!!! Thanks bunches.
Hi, Thanks for this!
I thought I messed the whole thing in my sites.
Thanks for sharing….
Woohoo!! You are a life saver and a time saver. I spent hours trying to fix one of my sites. I was just changing it to see what would happen. Guess I know now.
figaro thanks for quick and proper fix. I read up alot on this, others have you inserting text into your wp-config.php file but your strategy is a more sound principle.
@Scot Mann: You’re welcome…there is no substitute for fixing the problem in the db…editing wp-config is just a patch.
Thank you, you have no idea. I was pulling an all-nighter and at 4:30am (hours before launch) I got the fantastic idea to change the “general settings.” You are the greatest.
I followed every step you took, but nothing changed. I still get “Error establishing a database connection” do you have any more suggestions? I wold really appreciate it. Thanks man
@ackeem: Who is your host? Are you sure your db server is running? Was your site running and then this happened or are you trying to set this up for the first time? Give me some more info and I may be able to help. Link to your site?
Worked great! Thanks for saving my you know what!
Whew! Thanks for that help – extremely easy to fix a bad mistake. The reason I wanted to change the blog name, though, was that this wordpress installation is in a directory with its own add-on domain name. I’d rather the individual posts not include the name of the root and main domain name. You can go to the site using the add-on domain, but as soon as you click on another post or page, the whole domain structure shows up. Any help for how to keep that from happening?
@Susan: That shouldn’t happen if you have the add-on set-up properly with your host.
From despair to elation in 2 minutes. Thanks for a VERY useful tutorial.
Life saver. Such an easy video to follow! Thanks
hi,
thanks for the video… however, i’m on a mac and don’t know where to find the php my admin to do all those changes. any help would be greatly appreciated. thanks. using wordpress 2.9.2
@:aida: phpMyAdmin is on your webserver not your computer…you do it the same way I show in the video as long as your host provides access to phpMyAdmin. If you are hosting on your own computer, then you will need to search (Google) for how to do this on your MAC.
HI,
I really cannot thank you enough and this tutorial saved me much time and pain. I was ready to be on my way to the bookstore to buy WordPress for Dummies when I stumbled upon your tutorial! What a life saver you are!! 2 thumbs up!!!!
You just saved me sooooo much hassle LOL I knew the fix but couldn’t remember where it was! Problem solved!
Thank You!!! What a Super Great Tutorial!!! Thank You! Thank You!! Thank You!!!
You have just saved me from much grief and tears – thank you. Your wordpress tutorials are my lifeline! If you are ever in Scotland e.mail me and I will take you out for a meal!!
A million thank u’s!
thanks for that vid. it really helped me out!
al
Thanks this was helpful how do you change the website url without hurting the website
OMG. Thank you so much for this!
I can see by the comments and the number of them that I’m not the only person to lock themselves out of their site…. BRILLIANT TUT… I’m so glad this was the first result I clicked on in google… Stright and to the point!!… Thank you so much!!! May this page continue to rescue people in the future!!
Thanks! I locked myself out of a new blog and you just saved the day.
You’re a lifesaver! Really helpful tutorial
Thanks for the video. It saved my blog!