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

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 according to your taste
as well as help and support from the creators in case the user is stuck

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.

Add comment

Recent Posts


Recent Comments