117 | phpMyAdmin or Adminer? What if you have PostgreSQL? 🐘 A simple guide to choosing a database tool

2025-10-08

Congratulations! You just set up your web server (LAMP, LEMP, or something else) and are ready to build awesome websites. You have an operating system, a web server, a programming language, but one important puzzle piece remains — the database. Managing it without a convenient tool is like fixing a car without a wrench. 😅

If you use MySQL or MariaDB, you’ve probably heard of phpMyAdmin and Adminer. If you chose PostgreSQL, you also have great options! Let’s figure out which tool to choose so working with your database is easy and pleasant.

How to Restore Access to WordPress Administrator: Resetting Password via Database

2025-07-14

Losing access to the WordPress administrator account can be a real headache. Sometimes, standard password recovery methods (via email) don’t work, especially if:

• You forgot both your login and password.
• The site’s mail sending function (wp_mail) is broken.
• The WordPress admin panel is broken or unavailable.
• The only access left is to the database (via MySQL client, phpMyAdmin, WP-CLI, etc.).

In this article, we’ll walk through a reliable and secure way to find the WordPress administrator directly in the database and reset their password using SQL. We’ll follow DevSecOps best practices to avoid breaking serialized data and minimize risks.