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

  • Nathan_S
    replied
    Re: Change Theme Without Login To WordPress Admin Area

    You're welcome Susan and thanks for the appreciation .

    Leave a comment:


  • susansmith001
    replied
    Re: Change Theme Without Login To WordPress Admin Area

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

    Leave a comment:


  • Nathan_S
    replied
    Re: Change Theme Without Login To WordPress Admin Area

    You're welcome Daniel .

    Leave a comment:


  • DanielCzech
    replied
    Re: Change Theme Without Login To WordPress Admin Area

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

    Leave a comment:


  • 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.
Working...
X