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 bulk delete WordPress comments in PHPMyAdmin

Any user working on the computer system has the option in quickly deleting all the WordPress comments by using MySQL or phpMyAdmin....

Removing unwanted p and br tags from WordPress

When working with HTML, you sometimes don’t like your HTML editors because of the irritating automatic bugs. Yes, we are here with...

The 7 Best WordPress Plugins For Google Analytics 2020

As the saying goes, "what is not measured, is not managed." After setting up a WordPress website, it’s important to see what’s...

How to hide all WordPress update notifications in dashboard

When working on a project, it can be frustrating to have to deal with all the update notifications that are in the...

How to add custom HTML to wp_nav_menu

WordPress has a lot of features that help us solve almost all daily tasks of any programmer or web developer. Due to...

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