

Occasionally, in the Support Forums, someone will post a SQL query of some benefit or other that can be run using phpMyAdmin. The phpMyAdmin program is handy for performing maintenance operations on tables, backing up information, and editing things directly in the event that WordPress is not working. A “raw” view of the data, tables and fields stored in the MySQL database is accessible through phpMyAdmin. WordPress stores all of its information in the MySQL database and interacts with the database to generate information within your WordPress site. What is phpMyAdmin?Īn administrator’s tool of sorts, phpMyAdmin is a PHP script meant for giving users the ability to interact with their MySQL databases. If you seek help with your specific problem, please refer to the Support forums. Now all you have got to do is to visit your website and test the theme.Important: Please note that this is not a support page. After doing all this you theme will be activated on your website. You have got to repeat the same process with the stylesheet row. Once you are done editing, click on the ‘Go’ button. You have to alter the value of the option_value field to the theme that you wish to use on your website. Once you have clicked on the ‘Edit’ button, a row editor will open up. In the table, you will have to find the ‘template’ and ‘stylesheet’ rows and then click on the button in the extreme left that reads ‘Edit’. If someone has changed the database prefix then you will see something else instead of the default WordPress prefix, i.e., wp_. You will have to find the ‘wp_options’ table.

Once you have found it, click on it.Ĭlicking on your database will display all the tables present in it. You need to look for the database, that you are using for this site, from this list. This list will be the list of databases which will be displayed on the left side under the phpMyAdmin logo. The previous step will take you to phpMyAdmin where you will find a list. Now you will have to find the phpMyAdmin option under the database section in the cPanel dashboard of your WordPress hosting account. Then make a note of the name of the folder of the theme that is to be installed. Once you have opened this folder you will see all the installed themes. Then you have to navigate to the /wp-content/themes/ folder. Once done, follow the following steps.įirst of all, you need to open your FTP client which will help you in connecting to your website.
#Phpmyadmin themes install#
But in case it isn’t, then you can install the theme manually by FTP. You will need the theme, that you are switching to, to be preinstalled on your website. In this method, you can change the information in the database to let WordPress know that which theme is to be used. Using phpMyAdmin to change WordPress theme However, using a backup you can easily make your way to the WordPress admin area and then use this method.īut in case you don’t even have a backup then changing your WordPress theme from the database using phpMyAdmin will definitely help you out in this case. This error can refrain you from using this easy method. But sometimes you are unable to even access your WordPress admin area. We just have to click on Appearance in the menu and then click on theme option to choose the theme which needs to be activated. Well, we all know that nothing is easier than using the WordPress admin area for changing the theme. If this is the case with you, we have got you covered. You might not be able to access your WordPress admin area on many occasions.

Managing themes from the WordPress admin area is really easy but accessing your WordPress admin area isn’t that easy sometimes.
