CONTACT US: 1-800-622-4403
CUSTOMER LOGIN
Domains To Datacenter Since 1994

How to disable all Wordpress plugins using MySQL

Before beginning, make a backup copy of your database.

Then, login to your database using phpMyAdmin, and navigate to the “active_plugins” column of the “wp_options” table 

Once the active_plugins column appears, click to edit it.

You will see something similar to the following, depending on the number and type of plugins you have installed:

a:31:{i:0;s:13:"AddMySite.php";i:1;s:19:"akismet/akismet.php";i:2;s:23:"all_in_one_seo_pack.php";i:3;s:16:"authenticate.php";i:4;s:28:"breadcrumb-navigation-xt.php";i:5;s:18:"codeautoescape.php";i:6;s:37:"contact-coldform/contact_coldform.php";i:7;s:32:"custom-query-string-reloaded.php";i:8;s:30:"customizable-post-listings.php";i:9;s:33:"dd-sitemap-gen/dd-sitemap-gen.php";i:10;s:20:"download-counter.php";i:11;s:13:"feedcount.php";i:12;s:13:"full_feed.php";i:13;s:15:"get-weather.php";i:14;s:36:"google-sitemap-generator/sitemap.php";i:15;s:13:"gravatars.php";i:16;s:19:"kill-admin-nags.php";i:17;s:18:"landingsites13.php";i:18;s:30:"nofollow-free/nofollowfree.php";i:19;s:17:"ol_feedburner.php";i:20;s:16:"plugins-used.php";i:21;s:22:"popularity-contest.php";i:22;s:39:"search-everything/search_everything.php";i:23;s:27:"simple-tags/simple-tags.php";i:24;s:26:"simple_recent_comments.php";i:25;s:18:"simple_twitter.php";i:26;s:25:"subscribe-to-comments.php";i:27;s:24:"the-excerpt-reloaded.php";i:28;s:18:"theme-switcher.php";i:29;s:9:"top10.php";i:30;s:16:"wp-db-backup.php";}

That entire array of code represents every active plugin on your site.

Thus, to quickly disable all plugins without using the WP Admin area, highlight the entire block of code, cut it out, and paste it into a safe, offline text file.

After removing the code, click the button to save your changes and that’s it.

All WordPress plugins are now deactivated (yet still installed, and with all plugin options intact).

This obviously is a huge time-saver that really comes in handy during those mission-critical, time-sensitive situations where every second counts.

Once you are ready to re-activate your entire set of plugins, simply cut/copy & paste the preserved code back into the “active_plugins” field.

Click save and done.

Again, don’t forget to backup your database before editing it!


Buy SSL Certificates starting at $39


Buy Hosted Exchange - money back guarantee


Buy Windows Hosting - money back guarantee


Buy Managed WordPress Hosting - money back guarantee


Buy Windows VPS Hosting - money back guarantee


Website Hosting

  1. How To Install WordPress
  2. How to modify CSS on Mobile Devices
  3. Change Your Domain Name using WordPress
  4. How to enable .NET 4.0 for your POA Account.
  5. How to remove Pages/Posts from Wordpress Search
  6. How to disable all Wordpress plugins using MySQL
  7. Remove index.php from Wordpress URL
  8. How to move a Drupal site from one host to another
  9. How to move a Wordpress site from one host to another
  10. How to change the Wordpress site URL
  11. Masking Your Email from Spammers with WordPress + PHP
  12. How to Redirect a Registered Domain
  13. Changing the Wordpress URL Path to web root "/" or another path
  14. Simple Way to Secure a WordPress Website
  15. How to restart your website in Control Panel.
  16. How to Block Referral SPAM from your Website
  17. Creating Campaigns in Google Analytics
  18. Switching over to a New InfoQuest account.
  19. Stopping your website through the customer control panel (POA).
  20. Deleting a domain from your account.
  21. Where do I go to view my web stats (AWStats) for my site?
  22. How to change Wordpress siteURL to IP address using phpmyadmin
  23. How to enable "anonymous access" to browse my site.
  24. How to access Wordpress files.
  25. How to add a dedicated/exclusive IP address to your account.
  26. How to upload website content to the server.
  27. Update Directory Path for Website.
  28. Password protecting a folder on your site on POA.
  29. Add Structured Data Location Schema to your website
  30. How to delete WordPress Comments using phpmyadmin
  31. How to password protect a specific directory on your POA Hosting Account.
  32. Adding A Domain To My Account. (POA)
  33. Using a Web.Config Redirect
  34. Using CDOSYS with POA accounts without authentication
  35. Permanent 301 redirect
  36. Using CDOSYS with POA accounts with authentication
  37. How to force https in WordPress using web.config
  38. How to force https in WordPress using htaccess
  39. Cold Fusion DSN not working
  40. Enable New Exclusive IP Address for Website Hosting
  41. Changing from a Shared IP address to a Dedicated/New Exclusive IP address.
  42. Adding MIME Types For Your Account. (POA)
  43. Can I host multiple domains with InfoQuest's WordPress Hosting Plans?

Feedback and Knowledge Base