KNOWNHOST WIKI

User Tools

Site Tools


cms:wordpress:how-to-change-wordpress-themes-plugins-via-phpmyadmin

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
cms:wordpress:how-to-change-wordpress-themes-plugins-via-phpmyadmin [2019/10/10 13:41]
Karson N.
cms:wordpress:how-to-change-wordpress-themes-plugins-via-phpmyadmin [2020/06/10 13:44] (current)
Karson N.
Line 8: Line 8:
 This process is rather straightforward but due to the nature of editing databases we do recommend that you create a backup prior to beginning any work! This process is rather straightforward but due to the nature of editing databases we do recommend that you create a backup prior to beginning any work!
 {{howhard>3}} {{howhard>3}}
 +
 +\\
 ===== Deactivating WordPress Plugins ===== ===== Deactivating WordPress Plugins =====
  
Line 14: Line 16:
 They use a long string that looks like this They use a long string that looks like this
  
-<code>a:8:{i:0;s:19:"akismet/akismet.php";i:1;s:43:"all-in-one-seo-pack/all_in_one_seo_pack.php";i:2;s:36:"contact-form-7/wp-contact-form-7.php";i:3;s:37:"disable-comments/disable-comments.php";i:4;s:9:"hello.php";i:5;s:27:"redirection/redirection.php";i:6;s:43:"shortcodes-ultimate/shortcodes-ultimate.php";i:7;s:23:"wordfence/wordfence.php";}+<code> 
 +  a:8:{i:0;s:19:"akismet/akismet.php";i:1;s:43:"all-in-one-seo-pack/all_in_one_seo_pack.php";i:2;s:36:"contact-form-7/wp-contact-form-7.php";i:3;s:37:"disable-comments/disable-comments.php";i:4;s:9:"hello.php";i:5;s:27:"redirection/redirection.php";i:6;s:43:"shortcodes-ultimate/shortcodes-ultimate.php";i:7;s:23:"wordfence/wordfence.php";}
 </code> </code>
  
Line 27: Line 30:
 You're going to want to login to your cPanel account and navigate to PHPMyAdmin You're going to want to login to your cPanel account and navigate to PHPMyAdmin
  
-{{:cms:wordpress:php-1.png?nolink&400|}}+{{:cms:wordpress:php-1.png?nolink&1200|}}
  
 Once inside you're going to see a list of your databases on the left -- in this case; we're using 'khtest_wp' -- we'll then go to the 'wp_options' table. Once inside you're going to see a list of your databases on the left -- in this case; we're using 'khtest_wp' -- we'll then go to the 'wp_options' table.
  
-{{:cms:wordpress:php-2.png?nolink&400|}}+{{:cms:wordpress:php-2.png?nolink&1200|}}
  
 Within this next page you'll see a bunch of data in what is called 'rows' -- rows are numerical and start from 1.  Within this next page you'll see a bunch of data in what is called 'rows' -- rows are numerical and start from 1. 
Line 37: Line 40:
 We'll want to go to 'page 2' and search for row 33; you'll see the following We'll want to go to 'page 2' and search for row 33; you'll see the following
  
-{{:cms:wordpress:php-3.png?nolink&400|}}+{{:cms:wordpress:php-3.png?nolink&1200|}}
  
 We'll want to modify this value. You can do this by double-clicking on it and it'll enlarge the text place to modify. We'll want to modify this value. You can do this by double-clicking on it and it'll enlarge the text place to modify.
  
-{{:cms:wordpress:php-3-1.png?nolink&400&|}}+{{:cms:wordpress:php-3-1.png?nolink&1200|}}
  
 At this point; if you want to reset the entire active plugin we replace that entire line with the following At this point; if you want to reset the entire active plugin we replace that entire line with the following
  
-<code>a:0:{}</code>+<code> 
 +  a:0:{} 
 +</code>
  
 This deactivates all plugins that are currently active and marks them as disabled. This deactivates all plugins that are currently active and marks them as disabled.
Line 59: Line 64:
 a:8: becomes a:7: and then I'll remove my redirection plugin 'i:5;s:27:"redirection/redirection.php";' and delete it from the line which gives me the following a:8: becomes a:7: and then I'll remove my redirection plugin 'i:5;s:27:"redirection/redirection.php";' and delete it from the line which gives me the following
  
-<code>a:7:{i:0;s:19:"akismet/akismet.php";i:1;s:43:"all-in-one-seo-pack/all_in_one_seo_pack.php";i:2;s:36:"contact-form-7/wp-contact-form-7.php";i:3;s:37:"disable-comments/disable-comments.php";i:4;s:9:"hello.php";i:6;s:43:"shortcodes-ultimate/shortcodes-ultimate.php";i:7;s:23:"wordfence/wordfence.php";}</code>+<code> 
 +  a:7:{i:0;s:19:"akismet/akismet.php";i:1;s:43:"all-in-one-seo-pack/all_in_one_seo_pack.php";i:2;s:36:"contact-form-7/wp-contact-form-7.php";i:3;s:37:"disable-comments/disable-comments.php";i:4;s:9:"hello.php";i:6;s:43:"shortcodes-ultimate/shortcodes-ultimate.php";i:7;s:23:"wordfence/wordfence.php";} 
 +</code>
  
 Now I only have 7 active plugins and I can login to my WordPress dashboard again. Now I only have 7 active plugins and I can login to my WordPress dashboard again.
Line 65: Line 72:
 However, the easiest solution due to the ability to simply re-enable plugins in WordPress is most likely to just deactivate all plugins as noted earlier in this guide. However, the easiest solution due to the ability to simply re-enable plugins in WordPress is most likely to just deactivate all plugins as noted earlier in this guide.
  
 +\\
 ==== Changing WordPress Theme ==== ==== Changing WordPress Theme ====
  
Line 73: Line 81:
 You're going to want to login to your cPanel account and navigate to PHPMyAdmin You're going to want to login to your cPanel account and navigate to PHPMyAdmin
  
-{{:cms:wordpress:php-1.png?nolink&400|}}+{{:cms:wordpress:php-1.png?nolink&1200|}}
  
 Once inside you're going to see a list of your databases on the left -- in this case; we're using 'khtest_wp' -- we'll then go to the 'wp_options' table. Once inside you're going to see a list of your databases on the left -- in this case; we're using 'khtest_wp' -- we'll then go to the 'wp_options' table.
  
-{{:cms:wordpress::php-2.png?nolink&400|}}+{{:cms:wordpress::php-2.png?nolink&1200|}}
  
 Within this next page you'll see a bunch of data in what is called 'rows' -- rows are numerical and start from 1.  Within this next page you'll see a bunch of data in what is called 'rows' -- rows are numerical and start from 1. 
Line 89: Line 97:
 </WRAP> </WRAP>
  
-{{:cms:wordpress:php-2-1.png?nolink&400|}}+{{:cms:wordpress:php-2-1.png?nolink&1200|}}
  
 We're going to want to modify these two values of 'bhost' (or whatever your theme name is!) to another theme that exists on the server. We're going to want to modify these two values of 'bhost' (or whatever your theme name is!) to another theme that exists on the server.
Line 97: Line 105:
 Method #1 -- double click on the row where 'bhost' is located and it'll turn into an editing box. Method #1 -- double click on the row where 'bhost' is located and it'll turn into an editing box.
  
-{{:cms:wordpress:php-2-2.png?nolink&400|}}+{{:cms:wordpress:php-2-2.png?nolink&1200|}}
  
 You would then change 'bhost' to your a default WordPress theme such as 'twentynineteen' -- or whatever theme you have available. Simply click off to the side or it to save changes You would then change 'bhost' to your a default WordPress theme such as 'twentynineteen' -- or whatever theme you have available. Simply click off to the side or it to save changes
Line 103: Line 111:
 Method #2 -- clicking on the 'edit' button to the left will bring up a larger screen. Method #2 -- clicking on the 'edit' button to the left will bring up a larger screen.
  
-{{:cms:wordpress:php-2-3.png?nolink&400|}}+{{:cms:wordpress:php-2-3.png?nolink&1200|}}
  
 Same as Method #1; you would change 'bhost' to your a default WordPress theme such as 'twentynineteen' -- or whatever theme you have available. Same as Method #1; you would change 'bhost' to your a default WordPress theme such as 'twentynineteen' -- or whatever theme you have available.
cms/wordpress/how-to-change-wordpress-themes-plugins-via-phpmyadmin.1570732905.txt.gz · Last modified: 2019/10/10 13:41 by Karson N.