{"id":48287,"date":"2019-10-10T09:01:46","date_gmt":"2019-10-10T14:01:46","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/?p=48287"},"modified":"2023-05-17T18:09:14","modified_gmt":"2023-05-17T22:09:14","slug":"how-to-deactivate-plugins-from-the-wordpress-database","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/","title":{"rendered":"How To Deactivate Plugins From The WordPress Database"},"content":{"rendered":"\n<p>\nWhat if a plugin takes down your site? Try to log in and disable it. What if you can&#8217;t log in because the whole site is down? In this article, learn how to deactivate plugins from the database using <a href=\"\/support\/edu\/cpanel\/manage-mysql-database-in-phpmyadmin\/\">phpMyAdmin<\/a> or your favorite database editor.\n<\/p>\n\n<div id=\"text-table-of-contents\">\n<ul>\n<li><a href=\"#org3e7ba5b\">Why You Should Go Through The Database<\/a><\/li>\n<li><a href=\"#orgb082e5b\">Where Can You Find Plugins In The Database?<\/a><\/li>\n<li><a href=\"#org5dfe08e\">Serialized Data Editor<\/a><\/li>\n<li><a href=\"#org097a680\">How To Disable WordPress Plugins From The Database<\/a><\/li>\n<\/ul>\n<\/div>\n\n<p>\nYou will be editing your list of activated plugins by editing PHP serialized arrays. This is an advanced move, but in this article you&#8217;ll find great resources that will be of huge help to you.\n<\/p>\n\n<div id=\"outline-container-org3e7ba5b\" class=\"outline-2\">\n<h2 id=\"org3e7ba5b\">Why You Should Go Through The Database<\/h2>\n<div class=\"outline-text-2\" id=\"text-org3e7ba5b\">\n<p>\nYour database editor lets you access the plugins without affecting your file structure. For example, if you wanted to deactivate plugins by renaming a folder, you would need to access your file system. But you can accomplish this same effect much faster (and more safely) by using the database as your backdoor solution.\n<\/p>\n<\/div>\n<\/div>\n\n<div id=\"outline-container-orgb082e5b\" class=\"outline-2\">\n<h2 id=\"orgb082e5b\">Where Can You Find Plugins In The Database?<\/h2>\n<div class=\"outline-text-2\" id=\"text-orgb082e5b\">\n<p>\nYou will find a list (in serialized array) in the &#8220;wp-options&#8221; table of your WordPress database. There you&#8217;ll find the row labeled <code>\"active_plugins\"<\/code>. This is the table and row you will need to edit to deactivate plugins.\n<\/p>\n<\/div>\n<\/div>\n\n<div id=\"outline-container-org5dfe08e\" class=\"outline-2\">\n<h2 id=\"org5dfe08e\">Serialized Data Editor<\/h2>\n<div class=\"outline-text-2\" id=\"text-org5dfe08e\">\n<p>\nIn order to edit serialized data safely, you need to use special editors that help you avoid any human error. The editor suggested in this article was developed by Delicious Brains and makes it very easy to <a href=\"https:\/\/serializededitor.com\/\">edit serialized arrays<\/a>.\n<\/p>\n<\/div>\n<\/div>\n\n<div id=\"outline-container-org097a680\" class=\"outline-2\">\n<h2 id=\"org097a680\">How To Disable WordPress Plugins From The Database<\/h2>\n<div class=\"outline-text-2\" id=\"text-org097a680\">\n<ol class=\"article_list\">\n<li>Log into cPanel<\/li>\n<li>Click <b>phpMyAdmin<\/b> under <i>Databases<\/i><\/li>\n<li>Locate the WordPress database you need to edit<\/li>\n<li>Locate the <i>active_plugins<\/i> row in the &#8220;wp-options&#8221; table<\/li>\n<li>Copy the serialized data in <i>active_plugins<\/i> and copy it into the serialized data editor<\/li>\n<li>Uncheck the plugins you wish to deactivate<\/li>\n<li>Restore the edited array into your database<\/li>\n<li>(Optional) Paste <code>a:0:{}<\/code> to disable all plugins<\/li>\n<li>Save your changes<\/li>\n<\/ol>\n\n<p>\nWell done! You just deactivated WordPress plugins from your database. Improve your WordPress master skills further in the WordPress education channel.\n<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>What if a plugin takes down your site? Try to log in and disable it. What if you can&#8217;t log in because the whole site is down? In this article, learn how to deactivate plugins from the database using phpMyAdmin or your favorite database editor. Why You Should Go Through The Database Where Can You<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/\"> Read More ><\/a><\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[56,4305],"tags":[],"class_list":["post-48287","post","type-post","status-publish","format-standard","hentry","category-wordpress","category-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Deactivate Plugins From The WordPress Database<\/title>\n<meta name=\"description\" content=\"Learn how to deactivate plugins from the WordPress database. This method of disabling plugins uses a MySQL client (phpMyAdmin) to add code to the database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Deactivate Plugins From The WordPress Database\" \/>\n<meta property=\"og:description\" content=\"Learn how to deactivate plugins from the WordPress database. This method of disabling plugins uses a MySQL client (phpMyAdmin) to add code to the database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-10T14:01:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-17T22:09:14+00:00\" \/>\n<meta name=\"author\" content=\"Christopher Maiorana\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Maiorana\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/\"},\"author\":{\"name\":\"Christopher Maiorana\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/c6922c56c84e17079fd558e07b7ef72f\"},\"headline\":\"How To Deactivate Plugins From The WordPress Database\",\"datePublished\":\"2019-10-10T14:01:46+00:00\",\"dateModified\":\"2023-05-17T22:09:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/\"},\"wordCount\":355,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"articleSection\":[\"WordPress Tutorials\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/\",\"name\":\"How to Deactivate Plugins From The WordPress Database\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"datePublished\":\"2019-10-10T14:01:46+00:00\",\"dateModified\":\"2023-05-17T22:09:14+00:00\",\"description\":\"Learn how to deactivate plugins from the WordPress database. This method of disabling plugins uses a MySQL client (phpMyAdmin) to add code to the database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Deactivate Plugins From The WordPress Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/c6922c56c84e17079fd558e07b7ef72f\",\"name\":\"Christopher Maiorana\",\"description\":\"Christopher Maiorana joined the InMotion community team in 2015 and regularly dispenses tips and tricks in the Support Center, Community Q&A, and the InMotion Hosting Blog.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/chris-m-4623144b\/\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/christopherm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Deactivate Plugins From The WordPress Database","description":"Learn how to deactivate plugins from the WordPress database. This method of disabling plugins uses a MySQL client (phpMyAdmin) to add code to the database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/","og_locale":"en_US","og_type":"article","og_title":"How to Deactivate Plugins From The WordPress Database","og_description":"Learn how to deactivate plugins from the WordPress database. This method of disabling plugins uses a MySQL client (phpMyAdmin) to add code to the database.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2019-10-10T14:01:46+00:00","article_modified_time":"2023-05-17T22:09:14+00:00","author":"Christopher Maiorana","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Christopher Maiorana","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/"},"author":{"name":"Christopher Maiorana","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/c6922c56c84e17079fd558e07b7ef72f"},"headline":"How To Deactivate Plugins From The WordPress Database","datePublished":"2019-10-10T14:01:46+00:00","dateModified":"2023-05-17T22:09:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/"},"wordCount":355,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"articleSection":["WordPress Tutorials","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/","name":"How to Deactivate Plugins From The WordPress Database","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"datePublished":"2019-10-10T14:01:46+00:00","dateModified":"2023-05-17T22:09:14+00:00","description":"Learn how to deactivate plugins from the WordPress database. This method of disabling plugins uses a MySQL client (phpMyAdmin) to add code to the database.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How To Deactivate Plugins From The WordPress Database"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/c6922c56c84e17079fd558e07b7ef72f","name":"Christopher Maiorana","description":"Christopher Maiorana joined the InMotion community team in 2015 and regularly dispenses tips and tricks in the Support Center, Community Q&A, and the InMotion Hosting Blog.","sameAs":["https:\/\/www.linkedin.com\/in\/chris-m-4623144b\/"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/christopherm\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":56,"name":"WordPress Tutorials","slug":"wordpress","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/48287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=48287"}],"version-history":[{"count":9,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/48287\/revisions"}],"predecessor-version":[{"id":83195,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/48287\/revisions\/83195"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=48287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=48287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=48287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}