• Resolved koina

    (@koina)


    (((E-Z Fix But Don’t Know It!))) Unable to log-in to my WP admin – Re-Direct locking up my site

    I mistakenly changed my blog address (URL) in my General Options window from “https://yum.tv/wordpress” to one of my category post URLs and have locked up the site. Now I cannot login to my admin panel. How do I change it back or how can I find a back door into my admin panel to change the blog address (URL) back to “https://yum.tv/wordpress”?

Viewing 7 replies - 1 through 7 (of 7 total)
  • You could probably fix it by going into your wordpress database (using phpMyAdmin for instance). Go to the table wp_options and in the right portion of the screen look for the tab that says ‘SQL’. Click it.

    There should be a textbox on the page now, with something like ‘run SQL queries on database […]’ where […] is the name of the database you use for WordPress. Copy this into the textbox:

    UPDATE wp_options SET option_value = ‘[blog adress]’ WHERE option_name = ‘home’;

    Replace [blog_adress] with the URL of your blog (https://yum.tv/wordpress right?). Now click start.

    This works for me on my local setup and should work for you.

    Thread Starter koina

    (@koina)

    Hi Walter,

    Thank yo for the great response. Unfortunately I do not know sQL how much would you charge to do this?

    Please?

    Thread Starter koina

    (@koina)

    Hi whooami,

    Here’s my wp-config.php BUT I CANT FIND:
    “WP_HOME” or “WP_SITEURL” fields in it.

    <?php
    // ** MySQL settings ** //
    define(‘WP_CACHE’, true); //Added by WP-Cache Manager
    define(‘DB_NAME’, ‘yumtv_wordpress’); // The name of the database
    define(‘DB_USER’, ‘xxxxxx_wp’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘xxxxxx’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
    define(‘DB_CHARSET’, ‘utf8’);
    define(‘DB_COLLATE’, ”);

    // You can have multiple installations in one database if you give each a unique prefix
    $table_prefix = ‘wp_’; // Only numbers, letters, and underscores please!

    // Change this to localize WordPress. A corresponding MO file for the
    // chosen language must be installed to wp-content/languages.
    // For example, install de.mo to wp-content/languages and set WPLANG to ‘de’
    // to enable German language support.
    define (‘WPLANG’, ”);

    /* That’s all, stop editing! Happy blogging. */

    define(‘ABSPATH’, dirname(__FILE__).’/’);
    require_once(ABSPATH.’wp-settings.php’);
    ?>

    its not there, because you have NOT added it.

    You add that stuff, then it’s there.

    and please tell me you didnt just paste your mysql username and password into that post? edit that out if you did.

    a little common sense, please.

    Thread Starter koina

    (@koina)

    How do I edit it out?

    There does not seem to be a field to do so.

    Thread Starter koina

    (@koina)

    BRILLIANT! IT WORKED THANKU WHOOAMI & WALTER!!!

    Now how do I delete my post with my info on it?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Unable to log-in to my WP admin, Re-Direct locking up my site’ is closed to new replies.