How to change a WordPress theme in MySQL

    WordPress is a powerful blogging platform that has made a name for itself in the world of online journals. While there’s a stiff competition between WordPress and Google’s Blogger, the former is considered for professional and preferred by users who like working on the more technical side. Along with separate plugins and widgets, there’s a plethora of themes available for WordPress in numerous categories and designed in ways to cater to a certain need.

    Depending on the nature of your blog you can either go for a free theme or go premium which are paid and provide extra customization options and additional features. Premium themes are available in online tech stores and various market places. Prices vary depending on the effort and time that went into creating them, along with the number of other options they come with. There are tutorials available on how to install and edit them ccording to your taste as well as help and support from the creators in case the user is stuck somewhere.

    If you’re using a custom theme on your WordPress blog, sometimes  installing new plugins or updates may not support your current theme, which will result in denial of access to the control panel to deal with the issue. But there’s a solution available. You will have to login to MySQL database and either revert or make necessary changes in order for the updates to be compatible with your theme. Here’s how to change a WordPress theme in MySQL.

    Start by logging in to your database control panel that’s phpMyadmin. If you don’t have an idea how to do it, you will find the MYySQL database server on your webhosting service provider’s website. Login to your account to access phpMyadmin, but it is recommended to create backup of your data since any changes made cannot be reverted.

    Once you’ve entered, on the left side you’ll see “click wp_options”. Click it to reveal the options table.

    Look for the terms template and stylesheet within the rows. They should probably be present on page 2 within the table. Find and click option_value to make changes to the template. Then you can either switch to a default WordPress theme or use a new one which is compatible with the plugins and updates installed on your blog. Press enter and the made changes will be saved. Repeat these steps for stylesheet and that should solve the problem.

    Your WordPress theme is now accessible and you can also enter the control

    There are also various other tutorials and detailed instructions available on the internet for those who don’t know how to handle technical issues. Or you can ask someone else to do it for you.

    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