In this short tutorial I'll share with you a simple method to disable plugins in phpMyAdmin for your WordPress website, should you ever need to.
A few days ago I ran into a little bit of pickle when I decided to delete my web browser history.
All was well until I tried to access my WordPress website's login page to get into my dashboard.
I couldn't log in because I couldn't actually remember the login URL itself.
It was no longer in my history, remember.
I know what you're thinking, the WordPress login URL is an easy one to remember, right?
Nope, because I'm currently using the Rename wp-login.php plugin.
So, the only way I could log into my site was if I disabled the rename plugin entirely. Except for one small problem.
I couldn't disable the plugin in the back end of WordPress because I couldn't remember the login URL to get into my site in the first place.
What I had to do instead was disable the plugin via phpMyAdmin, which is why I decided to write this short little tutorial to share with you the simple process, should you ever need to do it too.
Sometimes things happen that are beyond our normal control.
This method is ideal if for some reason you can't access your WordPress website or the user dashboard to disable a broken or faulty plugin.
Maybe a plugin has brought down your entire site, if so, this tutorial should help.
Let's get to it.
First thing you'll need to do is log into your website's web hosting cPanel.
If you are using SiteGround as your host provider by any chance, then great.
Once logged in, head over to Go to cPanel from your My Account page. See image below.
Next, scroll down the cPanel page until you see Databases. Click on the application phpMyAdmin. See image below.
Now identify and access the name of the database for your website.
You can usually tell which website your database belongs to by clicking on wp_options, and by the side of the option_name 'siteurl' you'll see your domain name. See image below.
OK, so now if you select page 2 (See blue circle below) from the wp_options page, you should find the option_name 'active_plugins' somewhere. See images below.
Now double-click on the option_value for active_plugins to open up the editor box. See image below.
Simply select all of the content inside the editor box and delete it. This will disable all of the plugins on your WordPress website.
If you want to disable just one culprit plugin, however, you'll need to take a closer and harder look at the values to identify the plugin name.
The line for each plugin usually starts with a value like this: s:02 and ends with something like this: i:18;
So for example: s:02:"name-of-the-plugin";i:18;
That being said, it is much easier to disable all of the plugins, you can always reactivate them when you are able to log into your WP dashboard the conventional way.
One you're done simply hit anywhere outside of the editor box and your database should automatically update itself with the new changes.
That's it, how simple was that?
Don't forget to log back into your WP site the normal way to reactivate the plugins again if you need to.
I hope it helps.
Subscribe to my Updates!
Enter your name and best email address below to subscribe to bi-weekly news, the latest blog posts, and special offers.
Start Planning Your Blogging Strategy For 2020 Today!