{"id":5344,"date":"2021-04-29T19:27:46","date_gmt":"2021-04-29T19:27:46","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=ht_kb&#038;p=5344"},"modified":"2024-10-16T09:25:06","modified_gmt":"2024-10-16T09:25:06","slug":"disable-wordpress-plugins-database","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/disable-wordpress-plugins-database\/","title":{"rendered":"How To Disable WordPress Plugins From The Database"},"content":{"rendered":"<p>Say you just installed a plugin you thought would be really helpful for your site and right after activating it, your site is now dark, broken, and sad. You can&#8217;t log in to your \/wp-admin to disable the plugin and you&#8217;re seemingly stuck. You need to disable the plugin but how?<\/p>\n<p>Did you know you can disable the plugin from the database itself? Yep, sure can! In this knowledgebase article, I&#8217;ll show you how!<\/p>\n<h2 id=\"how-to-disable-wordpress-plugins-from-the-database\">How To Disable WordPress Plugins From The Database<\/h2>\n    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\">Pro Tip:<\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tDisabling the plugin via the database is not the only way you can recover your site should a plugin take it down. There are several ways and it&#8217;s all about personal preference!     \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<p><strong>Step 1:<\/strong> Login to your cPanel. There&#8217;s a lot of ways to do this, but the sure fire easiest way is to login to your <a href=\"https:\/\/lab.chemicloud.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Client Area<\/a>, then open your cPanel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4061\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2020\/12\/lab.jpg\" alt=\"\" width=\"1674\" height=\"496\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2020\/12\/lab.jpg 1674w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2020\/12\/lab-300x89.jpg 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2020\/12\/lab-1024x303.jpg 1024w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2020\/12\/lab-768x228.jpg 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2020\/12\/lab-50x15.jpg 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2020\/12\/lab-1536x455.jpg 1536w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2020\/12\/lab-60x18.jpg 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2020\/12\/lab-100x30.jpg 100w\" sizes=\"auto, (max-width: 1674px) 100vw, 1674px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Once your cPanel is open, scroll down to the Database section and click the phpMyAdmin app to open the utility.<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-5345\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-5-783x221.png\" alt=\"\" width=\"643\" height=\"181\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-5-783x221.png 783w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-5-300x85.png 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-5-768x217.png 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-5-50x14.png 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-5-60x17.png 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-5-100x28.png 100w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-5.png 1324w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/a><strong>Step 3:<\/strong> Once phpMyAdmin is open, look for your database on the left side and click the + to expand the list of tables within the database.<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-5346\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-3-783x258.png\" alt=\"\" width=\"643\" height=\"212\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-3-783x258.png 783w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-3-300x99.png 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-3-768x253.png 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-3-50x16.png 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-3-1536x505.png 1536w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-3-60x20.png 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-3-100x33.png 100w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-3.png 1918w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/a><strong>Step 4:<\/strong> The table in which plugin data is stored is always in _options. Click the table name to open it in phpMyAdmin on the right side.<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-5347\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-4-783x583.png\" alt=\"\" width=\"643\" height=\"479\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-4-783x583.png 783w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-4-300x223.png 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-4-768x571.png 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-4-50x37.png 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-4-1536x1143.png 1536w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-4-60x45.png 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-4-100x74.png 100w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-4.png 1918w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/a><strong>Step 5:<\/strong> Use the pagination feature to go to page 2 of your database where you should see the option_name is active_plugins.<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-5348\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-4-783x621.png\" alt=\"\" width=\"643\" height=\"510\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-4-783x621.png 783w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-4-300x238.png 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-4-768x609.png 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-4-50x40.png 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-4-1536x1217.png 1536w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-4-60x48.png 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-4-100x79.png 100w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-4.png 1918w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/a><\/p>\n<p><strong>Step 6:<\/strong> Click the option_value, which in this case looks like this:<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/5-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-5350\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/5-4-783x69.png\" alt=\"\" width=\"643\" height=\"57\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/5-4-783x69.png 783w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/5-4-300x26.png 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/5-4-768x68.png 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/5-4-50x4.png 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/5-4-60x5.png 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/5-4-100x9.png 100w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/5-4.png 1352w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/a><\/p>\n<p>Note the portion in the orange box, this is the option_value. To open this text and see it fully, double click it.<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/6-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5351\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/6-2.png\" alt=\"\" width=\"509\" height=\"441\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/6-2.png 509w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/6-2-300x260.png 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/6-2-50x43.png 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/6-2-60x52.png 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/6-2-100x87.png 100w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><\/a>Keep in mind, yours will look different than what you see above because you will no doubt have different plugins installed than I do. \ud83d\ude42<\/p>\n<p><strong>Step 7:<\/strong> To disable your plugins, delete the text in this box. The plugins won&#8217;t be uninstalled, simply set to deactivated status.<\/p>\n<p>To save your changes, click anywhere in the table view outside of the box where you deleted the text.<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/7-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5352\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/7-2.png\" alt=\"\" width=\"608\" height=\"180\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/7-2.png 608w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/7-2-300x89.png 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/7-2-50x15.png 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/7-2-60x18.png 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/7-2-100x30.png 100w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\" \/><\/a><\/p>\n<p>You will see a message appear ever so briefly which states 1 row affected.<\/p>\n<p><strong>Step 8:<\/strong> Now return to your website and try to access your \/wp-admin and you should be able to!<\/p>\n<p>And that&#8217;s how you use phpMyAdmin to disable the plugins you&#8217;ve installed in your WordPress site!<\/p>\n<p>If you still encounter issues, be sure to contact our Happiness Engineers 24&#215;7!<\/p>\n<p class=\"p1\"><b>Struggling with WordPress issues? ChemiCloud is the hosting solution designed to save you time! <\/b><span class=\"s1\">\ud83e\udd13<\/span><b> Check out <\/b><b>our <\/b><a href=\"https:\/\/chemicloud.com\/managed-wordpress-hosting?utm_source=blog&amp;utm_medium=article#60b65e4e63b58\"><span class=\"s1\"><b>Managed WordPress hosting<\/b><\/span><\/a><b> plans!<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Say you just installed a plugin you thought would be really helpful for your site and right after activating it, your site is now dark, broken, and sad. You can&#8217;t log in to your \/wp-admin to disable the plugin and you&#8217;re seemingly stuck. You need to disable the plugin but&#8230;<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"ht-kb-category":[40],"ht-kb-tag":[],"class_list":["post-5344","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-wordpress"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/5344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/comments?post=5344"}],"version-history":[{"count":7,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/5344\/revisions"}],"predecessor-version":[{"id":8478,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/5344\/revisions\/8478"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=5344"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=5344"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=5344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}