Powered by eUKhost®

Announcement

Collapse
No announcement yet.

Change Theme Without Login To WordPress Admin Area

Collapse
This is a sticky topic.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Change Theme Without Login To WordPress Admin Area

    Following are the steps :::
    =================


    1) Check the database name from wp-config.php file.
    2) Backup the database using the following command from shell.
    =============================
    From cPanel ==> mysqldump database_name > database_name.sql
    From Plesk ==> mysqldump ľopt -uadmin -p`cat /etc/psa/.psa.shadow` database_name > database_name.sql
    =============================

    3) Now, login to phpmyadmin and select the database_name.
    4) In the database click on table wp_options .
    5) In wp_options click on Sql tab .
    6) Execute the following queries for finding out the current theme enabled for wordpress site.

    ****************************************
    SELECT *
    FROM wp_options
    WHERE option_name = 'template'
    OR option_name = 'stylesheet'
    OR option_name = 'current_theme';
    ****************************************

    7) Now, execute the following query for changing the theme for wordpress site.

    ****************************************
    UPDATE wp_options SET option_value = 'default' WHERE option_name = 'template';

    UPDATE wp_options SET option_value = 'default' WHERE option_name = 'stylesheet';

    UPDATE wp_options SET option_value = 'default' WHERE option_name = 'current_theme';
    ****************************************

    Insert default= theme name. For example if theme is twentyeleven, then query should be as below ::

    ****************************************
    UPDATE wp_options SET option_value = 'twentyeleven' WHERE option_name = 'template';

    UPDATE wp_options SET option_value = 'twentyeleven' WHERE option_name = 'stylesheet';

    UPDATE wp_options SET option_value = 'twentyeleven' WHERE option_name = 'current_theme';
    ****************************************


    For confirmation again execute the query::
    ****************************************
    SELECT *
    FROM wp_options
    WHERE option_name = 'template'
    OR option_name = 'stylesheet'
    OR option_name = 'current_theme';
    ****************************************

    You will get the following result somthing like as below in phpmyadmin ::

    ****************************************
    current_theme twentyeleven yes
    stylesheet twentyeleven yes
    template twentyeleven yes
    ****************************************


    ENJOY..........


    Nathan S.

  • #2
    Re: Change Theme Without Login To WordPress Admin Area

    That's quite fantastic. Great post. Keep sharing such informative things!

    Comment


    • #3
      Re: Change Theme Without Login To WordPress Admin Area

      You're welcome Daniel .

      Comment


      • #4
        Re: Change Theme Without Login To WordPress Admin Area

        thank you so much for delivering your knowledge that is a great post.......

        Comment


        • #5
          Re: Change Theme Without Login To WordPress Admin Area

          You're welcome Susan and thanks for the appreciation .

          Comment

          ban-img
          Working...
          X