Locked out of your WordPress website? No worries. This article explains how a server administrator can either force reset a user’s WordPress password or create a new WordPress admin user with a brand new password. Database and FTP methods are described.
Database
Weird Characters In WordPress? Here’s How To Clean Them Up
If you do WordPress site migrations often, you will at some point encounter the problem of weird characters (like “ and â€) appearing in your WordPress content. This article explains why this may happen and how to fix the problem.
Different Ways To Change The WordPress “siteurl” And “home” Links
Once in a while, you may need to manually change your WordPress siteurl and home links (e.g. when you’re migrating your entire website to a new domain). If not done right, your site may malfunction. Here are the different proper ways to do this.
What is a Dirty Read in SQL Server and How to Avoid Them?
A dirty read is a database activity that ruins your reports and applications. Dirty reads are often nightmares that require the help of database administrators and developers. This article explains dirty reads and what you can do to increase data integrity in your SQL Server queries.
Connect To Amazon RDS (Or Any Database) Using HeidiSQL Via SSH Tunneling
Connecting to databases via SSH Tunneling is something developers and IT professionals often need to do. And HeidiSQL is one of the more popular open-source database tools. While HeidiSQL fully supports SSH tunneling, there doesn’t seem to be any documentation about how to accomplish this. So, after struggling with this for a few hours and figuring it out, I put these instructions together to help others.
Implementing Pagination Using PHP And MySQL
An SQL SELECT statement may often return thousands of rows. And when building sites, we usually don’t want to dump all those rows onto a single page (for speed and UX reasons). Instead, we split the results across multiple pages via PAGINATION.