1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

May have just locked myself out of my site...

Discussion in 'Web Hosting' started by fredfred547, Apr 29, 2015.

  1. fredfred547

    fredfred547 Power Member

    Joined:
    Oct 6, 2014
    Messages:
    646
    Likes Received:
    302
    Location:
    USA
    Well this awkward. I was trying to change my site's URL to https and so I changed "http" to "https" just like the picture below.
    [​IMG]
    It now show https with a red line through it and the WP Admin log in page as well as the forgot password page is unresponsive. I click log in and it just refreshes the page. Any ideas on what to do?
    (Note: The site above is NOT my site, just an example of what I changed.)
     
  2. umerjutt00

    umerjutt00 Jr. VIP Jr. VIP

    Joined:
    Oct 28, 2011
    Messages:
    3,879
    Likes Received:
    2,125
    Occupation:
    Ninja
    Try this:

    Go into cpanel, phpMyAdmin, select the database of your website.
    Now click on wp_options and the first two rows will be of siteurl and home. Try changing these 2 and see if it works.
     
    • Thanks Thanks x 3
  3. fredfred547

    fredfred547 Power Member

    Joined:
    Oct 6, 2014
    Messages:
    646
    Likes Received:
    302
    Location:
    USA
    Haha how would I have done that? I now understand what I should've done in regards to the SSL certificate and what not but I can't correct my error because I can't even log in. :banghead:
     
  4. srb888

    srb888 Elite Member

    Joined:
    Jul 30, 2008
    Messages:
    3,267
    Likes Received:
    5,081
    Gender:
    Male
    Occupation:
    WebzSurfer
    Location:
    Sun, Mon, Tue, WTF, Sat!!! :)
    See what umer is suggesting. It's the perfect solution for you IMO.
     
  5. pxoxrxn

    pxoxrxn Supreme Member

    Joined:
    Dec 21, 2011
    Messages:
    1,398
    Likes Received:
    2,073
    HEY! That's my website. Change it back to http in the database (wp_options table).
     
  6. Nut-Nights

    Nut-Nights Jr. VIP Jr. VIP

    Joined:
    Jun 20, 2013
    Messages:
    5,290
    Likes Received:
    3,370
    Location:
    Hell
    Home Page:
    I think you follow a tut share on BHW ? its not a complete tut. Ask your hosting company to make your site normal like before.
     
  7. fredfred547

    fredfred547 Power Member

    Joined:
    Oct 6, 2014
    Messages:
    646
    Likes Received:
    302
    Location:
    USA
    Ok I made it to phpMyAdmin but I can't find wp-options. Here's what I see Capture.jpg
     
  8. umerjutt00

    umerjutt00 Jr. VIP Jr. VIP

    Joined:
    Oct 28, 2011
    Messages:
    3,879
    Likes Received:
    2,125
    Occupation:
    Ninja
    Select the database of your website. If you are not sure which one, then click each one by one > Go into wp_options. The one with the url of your website is the required databse. Once you click on database, many options will appear. Click on wp_option and the first two rows will be of siteurl and home. Click on edit and change the values back to http.
     
    • Thanks Thanks x 2
  9. fredfred547

    fredfred547 Power Member

    Joined:
    Oct 6, 2014
    Messages:
    646
    Likes Received:
    302
    Location:
    USA
    Did some digging around and found it, it was just in a different folder. Thank you SO MUCH to @umerjutt00 :clap2: and everyone else for the replies.
     
    • Thanks Thanks x 1
  10. fredfred547

    fredfred547 Power Member

    Joined:
    Oct 6, 2014
    Messages:
    646
    Likes Received:
    302
    Location:
    USA
    Yes, I was trying to find a picture to use as an example and remembered your post ( I read it a few days ago) and decided to use it. If that was a problem just let me know and I'll remove it.
     
  11. V

    V Elite Member

    Joined:
    May 18, 2012
    Messages:
    2,294
    Likes Received:
    2,590
    Occupation:
    Student
    Location:
    /tmp
    This is how I changed my site's URL when I was in a similar situation last year. :) You can modify a lot of things from wp_options ;)
     
  12. ChanzGrande

    ChanzGrande Elite Member

    Joined:
    Feb 16, 2008
    Messages:
    2,487
    Likes Received:
    1,177
    Occupation:
    Accountant
    Location:
    Northern Woods Counting Money
    This is not the preferred solution, nor will it work in every scenario. However, I'm happy your issue is resolved. Having done this many times myself I can tell you the best working solution is:

     
  13. srb888

    srb888 Elite Member

    Joined:
    Jul 30, 2008
    Messages:
    3,267
    Likes Received:
    5,081
    Gender:
    Male
    Occupation:
    WebzSurfer
    Location:
    Sun, Mon, Tue, WTF, Sat!!! :)
    He may not be an expert, or even an advanced user (php / FTP) to manage that solution though. :)
    So the other/first solution by umerjutt00 IS the preferred solution, and almost any newbie, who has some understanding of cpanel can use it almost flawlessly.

     
  14. Seven4

    Seven4 Power Member

    Joined:
    Nov 28, 2013
    Messages:
    684
    Likes Received:
    92
    I'm guessing this will solve his issue. It's easy enough to follow, so it's irrelevant if you're a newbie or an expert.