How to Change a WordPress Theme in MySql (PhpMyAdmin)

    New plugins or theme updates can brings new issues or errors in your current theme. Sometimes you need to change your theme or reset the password directly in the database because you are unable to enter the WordPress admin area to switch the theme. This article will help you on how to change a WordPress theme in MySQL database.

    To change WP theme in PhpMyAdmin follow these steps:

    1. Log in inside the phpMyAdmin and look to the left hand sidebar. Select and click on your specific WordPress database.
    2. From your WordPress database, select the wp_options table.
    3. Look to the horizontal tab menu on the screen and click on the Browse tab option (by default you are in this tab right now).
    4. Under the option_name column, find the template and stylesheet entries. You may find these records on the second page.

      template and stylesheet entries
      template and stylesheet entries
    5. Click on the Edit button in the same row with the template entry.
    6. Change the value to the name of your theme (the name must be the same as your theme’s folder name) in the option_value column.
    7. Save it.
    8. Do the same thing with the stylesheet entry.

    Now is your WordPress theme activated from within the database.

    Recent Articles

    How to remove category & tag base from WordPress URL

    Would you like to remove the category & tag base from WordPress URL? Do you need custom URL's? It's a super simple!...

    How to Disable Right Click on WordPress

    Are you worried about having your images stolen from your WordPress website? Then you need to know how to disable right click on...

    How to redirect HTTP to HTTPs in .htaccess

    Today's standard is to have an https certificate. Google will love you if your sites are secured. So https is not standard,...

    How to fix TypeError: $ is not a function in WordPress

    We can guess. You purchased a theme or plugin and a console shown a message "TypeError: $ is not a function"? Ok,...

    How to fix Unknown collation: ‘utf8mb4_unicode_520_ci’

    Unknown collation is probably caused because your local and live server are running different versions of MySQL. This problem mostly comes when...

    Related Stories

    Leave A Reply

    Please enter your comment!
    Please enter your name here

    Stay on op - Get the daily news in your inbox