The WordPress Dashboard is a lovely place. It has buttons. It has colors. It feels safe.

But sometimes, things go wrong.

Maybe a plugin decides to rebel and gives you the infamous “There has been a critical error on this website” message. Maybe you forgot your password and your email reset isn’t working. Maybe you just want to feel like a hacker in a 90s movie.

When the Dashboard locks you out, you don’t need to panic. You need phpMyAdmin.

Think of your website like a car. The Dashboard is the steering wheel. phpMyAdmin is popping the hood and staring directly at the engine. It looks scary, but with a gentle touch, you can fix almost anything.

Here are some cool tricks to rescue your site using phpMyAdmin and a few database tweaks.

The Golden Rule Before We Start

Make a Backup.

I am serious. Before you touch the database, export a copy. If you accidentally delete the users table instead of editing it, I cannot help you. I am a blog post, not a magician.

1. The “Bad Plugin” Takedown

The Scenario: You installed a plugin called “Super Ultra Speed Booster 3000.” Immediately, your site crashed. You can’t even access the dashboard to turn it off. You are staring at a critical error message.

The Fix: We are going to tell the database to turn off all the plugins so you can get back in.

1. Open phpMyAdmin and click your database.
2. Find the table wp_options (Note: your prefix might be different, like wp_55_options).
3. Look for the row named active_plugins.
4. Click Edit.
5. You will see a bunch of scary-looking text (serialized data). Select everything in option_value and replace it with: a:0:{}
6. Press Go.

The Result: You just forcefully deactivated every plugin on your site. Your site should load now! Go back into your dashboard, and turn them back on one by one, except the one that broke everything (of course). Burn that one.

2. The “Secret Agent” Password Reset

The Scenario: You forgot your admin password. The “Lost your password?” email link never arrived. You are locked out of your own house.

The Fix: We are going to break in through the back door.

1. Find the table wp_users (your prefix might be different, like wp_55_users).
2. Find your username and click Edit.
3. Look for the field user_pass. You’ll see a long string of random gibberish. That’s your hashed password.
4. Delete the gibberish and type your new password (e.g., ILoveWordPressYesIDo).
5. Crucial Step: In the “Function” dropdown menu next to it, select MD5. This tells phpMyAdmin to store your new password in a hashed format that WordPress will recognise on your next login.
6. Press Go.

3. The “Time Travel” (Changing Themes)

The Scenario: You activated a new theme, and your site immediately imploded. Critical error! You can’t log in to switch back to the default theme.

The Fix: We are going to force WordPress to wear its old clothes.

1. Open phpMyAdmin and select your WordPress database.
2. Go to the wp_options table (your prefix may be different, for example wp_55_options).
3. Find the row where option_name is template and click Edit.
   • In option_value, change it to the folder name of a default theme you know is installed, for example twentytwentytwo.
   • Press Go to save.
4. Do the same for the row where option_name is stylesheet: set option_value to the same theme folder name and save.

The Result: Your site will load with the default theme. It might look meh for a minute, but hey, at least you’re back in!

Conclusion: See? Not so scary (With a Backup)

phpMyAdmin isn’t a monster; it’s just a very literal, very helpful assistant that follows exact instructions. It does exactly what you tell it to do, no questions asked.

So the next time your WordPress site throws a tantrum, don’t despair. Crack your knuckles, open phpMyAdmin, and perform a little digital surgery.

---

If this whole “database rescue” thing felt more fun than frightening, your next trick might be wrangling WooCommerce products from the command line. A fellow techie wrote a handy guide on managing WooCommerce products via CLI.