Lost Access to WP Admin page by changing wordpress and site addresses

  • Resolved Jenxlilac

    (@jenxlilac)


    14 years, 2 months ago

    Hi,

    Please help. I’ve contructed my website using a local MAMP server on my computer and am now trying to export the content of the database to the remote host so I can test the site online.

    Before I got to that however, I went into the old local admin page and, using instructions from codex changed the wordpress address and site address fields in general settings to the domain name of my test site.

    Now I’m locked. How do I get back in? And if anyone knows of any simple instructions for exporting a MySQL database from a local server to a remote server I’d really like to read them.

    Thank you

Viewing 12 replies - 1 through 12 (of 12 total)

  • https://codex.www.ads-software.com/Changing_The_Site_URL#Changing_the_URL_directly_in_the_database

    ofcourse you’re locked out, you’ve just changed the address of your WordPress blog to an URL that probably doesn’t contain your copied-over files…

    Copy all your files and folders to your hosting environment. Then open wp-config.php and enter new dbase details.

    Now go to your database in PHPMyAdmin or alike, and do a find-replace action in your database tables from OLDLOCALADDRESS to NEWREMOTEADDRESS. After that login to your wp-admin on your NEW address.

    Thread Starter Jenxlilac

    (@jenxlilac)

    Erm…I’m very new to this and cannot easily understand any of those instructions. Where am I likely to find a hosting environment please?

    btw. As I said I was following instructions I found on Codex. We all have to start somewhere so to me there’s very little ‘of course’ about it. That said, I do very much appreciate the prompt response.

    You must have knowledge about logical structures in WordPress before attempting such a usually problematic part of maintaining a WP site.

    A hosting enviromment is just that, your hosting package, webspace, shared hosting package, your server, your space on the internet.

    Thread Starter Jenxlilac

    (@jenxlilac)

    Thank you for the link Roy but I’m now also locked out of phpmyadmin (403 forbidden message) which must have something to do with it as it was fine before this happened. How do I get back into that please ?

    Thread Starter Jenxlilac

    (@jenxlilac)

    Thank you for the link Roy but I’m now also locked out of phpmyadmin (403 forbidden message) which must have something to do with it as it was fine before this happened. How do I get back into that please ?

    follow Roy’s advice above to fix it back

    if you want to move the install
    https://codex.www.ads-software.com/Moving_WordPress#Moving_WordPress_Within_Your_Site

    Thread Starter Jenxlilac

    (@jenxlilac)

    Samuel B,
    Thank you, Roy’s advice is great but I’m locked out of phpmyadmin which I need to access to follow his instructions. Is it likely that I’ve lost access to phpmyadmin on MAMP because of the changes I made to WordPress that got me locked out of there or should I look for another reason and fix that first?

    try one of the other methods besides phpmyadmin
    https://codex.www.ads-software.com/Changing_The_Site_URL

    Your PHPmyadmin has nothing to do with the WP installation. It’s the backend of your host.

    Thread Starter Jenxlilac

    (@jenxlilac)

    Thank you all. Will explore all avenues.

    Thread Starter Jenxlilac

    (@jenxlilac)

    Matter resolved with ease. Thanks for the link Roy.

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Lost Access to WP Admin page by changing wordpress and site addresses’ is closed to new replies.