I Changed my Wordpress Site URL, and Now I'm Locked Out!
Hi All. I'm a bit of a N0ob, and this is my first question here, I do apologise if I'm doing this wrong?
I was just in my General Settings page in my Wordpress admin section, and I changed the http part of my site URL by adding an “s” character… (Someone told me I had to do this to enable https for my site. :-/ ) Anyway, now I’m locked out of my site and I can’t get back into the Wordpress admin to do anything.
I’ve tried so many different options as listed here: https://codex.wordpress.org/Changing_The_Site_URL, but they all ask for combinations of usernames, passwords etc, and I don’t know if that means Linode’s ones, or Wordpress ones… so confusing, and I can't even make a start without logging in.
Am I able to just go into say my-config.php here in Linode somehow and just directly delete that “s” from the URL? There must be some way I can manage to change it back to regain Wordpress access? Ps, I don't know how to use Lish. I've tried to, but I can't even get past the login Pluto password phase..
2 Replies
bthompson
Linode Staff
When logging in as root in Lish console, you need to enter the Linode's root password. You can reset your root password in the Linode Manager if you don't remember it.
If you're having trouble fixing the site URL by modifying configuration files, you might have better luck changing the URL directly in the database.
After logging into the system via SSH or Lish console, next login to your MySQL database.
Log into database as root:
mysql -u root
Add -p flag if you set a password for root:
mysql -u root -p
Select the Wordpress database:
mysql> use wordpress;
From here, follow the steps in this post for modifying the home and siteurl values. You may need to ensure that your wp-config.php file is the same as before the issue occurred.
Thank you. :-)