July 14, 2025
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.
June 28, 2025
We’ve already explored the powerful server-based giants MySQL and PostgreSQL, but the database world is much more diverse. Today, we’re turning to a unique player — SQLite. Unlike its “bigger brothers,” SQLite is not a standalone server but an embedded library that stores the entire database in a single file.
What is SQLite?
SQLite is a free and public domain relational database management system (RDBMS). Its defining feature — and what sets it apart from other DBMSs — is that it does not require a separate server process. SQLite is implemented as a compact C library embedded directly into your application. The database is stored in one or more standard disk files, making deployment and usage incredibly simple.
June 27, 2025
In the previous article, we covered MySQL — a reliable and popular leader in the world of relational databases. Today we turn to its main competitor, often called “the world’s most advanced open-source relational database” — PostgreSQL. Known for its strict SQL compliance, extensive feature set, and remarkable extensibility, PostgreSQL stands out among relational systems.
What is PostgreSQL?
PostgreSQL is a powerful, open-source (BSD-licensed) object-relational database management system (ORDBMS). It began as the POSTGRES project at the University of California, Berkeley in 1986 and was renamed PostgreSQL in 1996. Unlike purely relational systems, PostgreSQL incorporates object-oriented concepts, making it more flexible and powerful.
June 26, 2025
Following our overview of database types, it’s time to take a closer look at one of the most well-known and widely used players in the relational world — MySQL. Over the years, MySQL has become the de facto standard for web applications and is an integral part of the famous LAMP stack (Linux, Apache, MySQL, PHP/Python/Perl).
What is MySQL?
MySQL is a free and open-source (with a commercial version available from Oracle) relational database management system (RDBMS). It was created in the mid-1990s and quickly gained popularity due to its simplicity, speed, and reliability — especially for web applications. MySQL stores data in structured tables and uses SQL (Structured Query Language) to perform operations such as creating, reading, updating, and deleting data.
June 25, 2025
In today’s digital world, where every click, purchase, or message generates data, there’s a pressing need for efficient storage, management, and fast access. That’s exactly what database servers are for. They are the invisible but essential foundation of any dynamic application — from simple blogs and e-commerce platforms to complex enterprise systems, financial tools, and AI solutions.
What is a Database (DB) and Why Do You Need One?
A database (DB) is an organized collection of information, structured in a way that makes it easy to access, manage, and update. A database server is a software system that provides access and management services for one or more databases.
