TechnologyWordPress
How to Deactivate all Plugins from MySQL Database WordPress

How to Deactivate all Plugins from MySQL Database WordPress

By: SolutionsHint    31 views Updated: 05th Dec, 2017

In this tutorial i am going to explain “How to Deactivate all Plugins from MySQL Database WordPress” , its really useful post because some times we download  plugin  from WordPress Official site and uses for our blog without any testing  , during plugin  activation application get stop working due to the conflict & buggy code .

in this case our blog stop working and its directly reflect the users experience , so we have another way to deactivate or disable all plugin using WordPress database and table  and  blog start working  .

How to Deactivate all Plugins from MySQL Database WordPress

I am trying to explain on localhost server and using phpmyadmin to perform this task, by using this techniques you can deactivate all plugin of your blog and start working .

Steps Wise Explanation for Deactivate all Plugins from MySQL Database WordPress

1 ) Enter  ” http://localhost/phpmyadmin”  browser and you will redirected window of PHP Myadmin .

2 ) Click on Database which you are using for your application .

3 ) click on wp_options Table from selected database .

4 ) Find option_name   active_plugin active plugin place on option_id 23

Notes :

SELECT option_name, option_value
FROM wp_options
WHERE option_name = ‘active_plugins’
LIMIT 0 , 30

5 ) Click on option value and remove all value after removing value your all plugin will get Deactivated .

 Using MySQL Query

UPDATE wp_options SET option_value  =’ ‘ WHERE option_name = ‘active_plugin’ ;

Screenshot 1 : Before

How to Deactivate all Plugins from  MySQL Database WordPress

Screenshot 1 : Before

Deactivate all Plugins from  MySQL Database WordPress

Congratulation you have successfully deactivate plugin using database !!

About the Author

I am a professional blogger from my heart, I am going through all the possible ways that can help to audience. I am trying my best to write content that my readers will like me. I will really be happy when my readers will become more happy with my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

Tweet
Share
+1
Share1
0 Shares