Jun
26

Tutorial: Deactivate Plugin via phpMyAdmin

As promised in the previous post, this is a tutorial on how to deactivate ALL wordpress plugins through phpMyAdmin.

Firstly, I would like to tell and remind you that phpMyAdmin is a powerfull tool that allows you to modify whatever you wish. So be careful when handling it.

This is a part of solutions if you cant access your dashboard panel to deactivate the plugins. Other solutions can be as deleting or moving the plugin through your cpanel or ftp.

To disable all plugins using phpMyAdmin, login to your cpanel and click phpMyAdmin icon. After that, select your wordpress database that you want to alter.

Images below will appear after you have selected your database.

Click to enlarge

Click to enlarge.
You can drag it aside after that.

  1. Select the wp_options table from your database.
  2. Turn to ‘Browse’ tab.
  3. Under the option_name column (field), look for active_plugins.
  4. Then, click the pencil icon to edit the option_value.

    !Note: If you couldn’t find the active_plugins row, click the next button. You will find it on the next page.

  5. Click to enlarge
    Click to enlarge.
    You can drag it aside after that.

  6. Go to the option_value text area as highlighted in the above images. Select all the codes inside the area and replace it with a:0:{}
  7. Click ‘Go’ button to save the setting.

After you have done those steps, go to your wordpress login page and you are ready to access it again.

Extra note: Activate your plugin one-by-one to find which plugin is the ‘culprit’. You may need to wait until the plugin author released the newer compatible plugin version.

Hope this can help you. More info, go to Wordpress support forum.

Related Posts with Thumbnails
  1. July 11th, 2009 at 05:25 | #1

    I tried this as you instructed, but instead of allowing me to access my admin panel, I get the following message:

    Parse error: parse error, unexpected $ in /home/content/m/r/z/mrzippy13/html/wp-admin/menu-header.php on line 138

    Any suggestions?

  2. July 11th, 2009 at 12:30 | #2

    It seems like your menu-header.php file have missing or got syntax error in the script.

    Please re-upload the file using ftp or file manager in cpanel.

  3. August 9th, 2009 at 20:45 | #3

    Nice thank
    Thank you very much
    I try to manual disable plugin many time. but I can’t understand because I never use phpMyadmin until I find your blog It have a pictures that teach how to disable It’s make me understand.

    thx you
    thx you ^_^

  4. August 14th, 2009 at 01:56 | #4

    Glad I can help you. :)

  5. January 1st, 2010 at 15:09 | #5

    Excellent dude. It worked for me like charm. I had problem of cant see the publish buttons in add new page. Now the problem has solved. The culprit plugin was My Adsense 2.7 By Andre Renaut .

  1. No trackbacks yet.