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
panel.

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 Hide Shipping Methods in WooCommerce?

This is a small detail, but WooCommerce doesn't have built-in any function for hiding shipping methods based on different situations. Imagine when...

How to Get WordPress Post Featured Image URL

Are you a WordPress developer or an advanced WordPress user? Whoever you are, sometimes you may need the direct URL of a...

How to Bulk Delete Media in WordPress

WordPress and media. That's the topic for a book. Sometimes is not easy to find what you need and when you have...

Custom Order Number for WooCommerce Will Saves You a Lot of Hassle!

WordPress is still the king of Content Management Systems (CMS). Thanks to its open-source nature, millions upon millions of users and PHP...

How to Manually Sort WooCommerce Products

WooCommerce is an e-commerce plugin for WordPress. It is a great way for the user to create an online store for their...

Get in touch

Be our first-class reader, build a community and follow us on social media!

Leave A Reply

Please enter your comment!
Please enter your name here