WordPress Jetpack: deactivate any module

How to disable any module of JetPack for WordPress.

After I've installed the JetPack module I saw a lot of plugins I don't need at all but I did not have a deactivate button for them. To make them deactivated, you'll need a bit of database hacking:

To show the active modules list:

SELECT * FROM wp_options WHERE option_name='jetpack_active_modules';

The output should be something like this:

+-----------+------------------------+------------------------+----------+
| option_id | option_name            | option_value           | autoload |
+-----------+------------------------+------------------------+----------+
|    254164 | jetpack_active_modules | a:1:{i:0;s:5:"stats";} | yes      |
+-----------+------------------------+------------------------+----------+
1 row in set (0.00 sec)

To deactivate ALL the modules ( you will be able to activate one by one after this )

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

(Oh, by the way: this entry was written by Peter Molnar, and originally posted on petermolnar dot net.)