Deactivate WordPress plugins in phpMyAdmin

WordPress plugins are easiest to manage in WP Admin. However, sometimes you may need to deactivate your plugins in phpMyAdmin, for example, if you can't log in to WP Admin.

Deactivating plugins doesn't delete them from your WordPress installation, so if you need them again, you can always activate them in WP Admin.

• Step 1 - Log in to the Control Panel
• Step 2 - Select a database
• Step 3 - Click wp_options
• Step 4 - Locate the plugins
• Step 5 - Disable plugins

Note: Be very careful while working in phpMyAdmin, as it is not possible to undo changes. We recommend creating a backup before you make any changes.

Step 1 - Log in to the Control Panel

1. Log in to the one.com Control Panel.
2. Click Database settings under Hosting settings in the menu on the left.

Step 2 - Select a database

Under PhpMyAdmin in the top right, click Select database and choose the database you want to access.

Step 3 - Click wp_options

The database in phpMyAdmin opens in a new window. In the left-hand menu, click wp_options to open the options table.

Note: The table can have different prefixes, and in this example the prefix is www_. If you installed WordPress with our 1-click installation tool, the prefix is most likely the location of your WordPress site.

Step 4 - Locate the plugins

Find the row called active_plugins. It is usually located on page 2 in the options table.

Step 5 - Deactivate plugins

1. Double-click the option_value field for active_plugins.

2. Replace the existing value with:

   a:0:{}

3. Press Enter to save the change.

This temporarily deactivates all plugins by setting the active plugin list to an empty WordPress-compatible array. If this didn't solve your issue, you may want to manually change your WordPress theme.

Related articles:

• Change your WordPress password in the database
• Change your WordPress theme from the database