Question
Help! My site crashed when I updated site / wordpress address
- Posted February 4, 2020
- WordPress
Like a few folks in this help section, I built a one-click wordpress installation with digital ocean.
I host my personal domain - stefanpalios.com - through google domains. I set it up with custom nameservers to point to digital ocean. I then pointed the URL to my IP address of the digital ocean droplet - http://68.183.198.59/.
It was working ok, except when I typed in “stefanpalios.com” I got directed to “http://68.183.198.59/” and the IP is what showed in the address bar.
Following instructions from another thread, I updated my site + wordpress address in my wordpress dashboard, changing from http://68.183.198.59/ to https://stefanpalios.com. That effectively crashed my site – I now get a “This site can’t be reached. stefanpalios.com refused to connect.” error
I cannot access my wp-admin to change things back. How do I get my site back?!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hello, @stefanpalios
If you can access your database from the MySQL/MariaDB console you can change the home and site URLs from there.
You need to update the:
option_name: siteurlandoption_name: homeIf you’ve installed phpMyAdmin you can make this change from there as well. Alternatively if you have a database backup prior the change you can restore your database as well.
Hope this helps, let me know how it goes.
Regards, Alex