How to disable all WordPress plugins directly from the database?

You can easily disable all WordPress plugins directly from your database. This is useful when you have some problems with your WordPress installation such as not being able to log in to the admin area and/or having blank pages.

To disable all plugins, log in to phpMyAdmin and select your WordPress database from the menu on the left.

Browse the table wp_options and find the option active_plugins. Click the pencil icon to edit the table. Its content will vary, depending on what plugins you have enabled. For example, if you have the Akismet and Hello Dolly plugins enabled, the code there will be:

a:2:{i:0;s:19:"akismet/akismet.php";i:1;s:9:"hello.php";}

To disable all plugins, simply delete the code and click the Go button to save the change.

The other option is to use the following query to disable all of your WordPress plugins:

UPDATE wp_options SET option_value = '' WHERE option_name = 'active_plugins';

Please note that disabling the plugins will not remove them from your WordPress application. They will simply be deactivated. You can easily activate them from your WordPress admin area at any time.

WordPress is a powerful software that is easy to work with once you have the right host to support you. Before you lose any more time with the wrong host, check out the hostlantern WordPress hosting offer.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How to Leverage Browser Caching

Add these rules to your .htaccess file in order to reduce the load times of web pages by storing...

Why BackupBuddy fails to send backups to a remote server

When backing up to a remote server, the successful completion of the process relies on many...

How to Disable Theme Editor and Plugin Editor in WordPress Admin Panel

WordPress allows you to edit your plugin and theme files directly through its admin panel....

How to Modify my Title Tag in WordPress

To modify the title tag of your index page you need to login to the WordPress admin area and go...

How to Change my WordPress Subheading

The majority of WordPress themes take the subheading text from your blog's tagline. To edit it,...