Blog

Deactivating all WordPress plugins using an SQL statement

WordPress

To deactivate all WordPress plugins using SQL (for example, if the backend becomes unusable due to a plugin), you can use the following statement:

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

Note: If a different table prefix is set other than wp_ , the statement needs to be adjusted accordingly.