Technology Insights

Disable All WordPress Plugins From MySQL CLI Or PhpMyAdmin

I was creating a mirror copy of one of my WordPress installations recently and needed a way to disable all plugins. During the process of creating the development WordPress mirror there were issues so I needed to disable all WordPress plugins via MySQL since at the time I could not login to the WordPress admin. Below I will describe listing all of the active plugins with one MySQL command and then disabling all of the plugins with another MySQL command.