wordpress mysql usage statistics - WordPress MySQL Version Usage Statistics UPDATED

WordPress MySQL Version Usage Statistics UPDATED

As of 2021, the vast majority of WordPress websites are using MySQL version 5.6 or higher because WordPress has required at least MySQL version 5.6 since version 4.4, released in 2015. Newer MySQL versions are not yet widely adopted, as some users may be using older hosting environments that do not support them, or they … Read more

phpinfo WordPress Shortcode - phpinfo() WordPress Shortcode

phpinfo() WordPress Shortcode

Here is an example of a simple WordPress plugin that uses the [phpinfo] shortcode to display PHP information similar to what the phpinfo() function does: <?php /* Plugin Name: PHP Info Shortcode Description: Displays PHP information using the [phpinfo] shortcode. */ function phpinfo_shortcode_handler( $atts ) { // Build the HTML for the data $html = … Read more

How to Rename wp login.php  - How to Rename wp-login.php

How to Rename wp-login.php

It is generally not recommended to rename the wp-login.php file in a WordPress installation as this can cause issues with the WordPress site and may make it difficult or impossible to log in to the WordPress administration panel. However, if you still want to rename the wp-login.php file, you can do so by following these … Read more

Block access to WordPress for users coming from a specific website - Block access to WordPress for users coming from X website

Block access to WordPress for users coming from X website

There are a few different ways that you can block access to your WordPress website if a user is coming from a specific website: Blocking access using a plugin There are several WordPress plugins that allow you to block access to your website based on the referral URL. These plugins typically allow you to specify … Read more

Disable WordPress Comments - Disable WordPress Comments

Disable WordPress Comments

There are several ways to disable comments in WordPress: From the WordPress administration panel This will disable comments on all new posts and pages. If you want to disable comments on existing posts and pages, you can do so by editing each post or page and unchecking the “Allow comments” option. Using a plugin There … Read more

SVN Checkout a WordPress plugin - SVN Checkout a WordPress plugin

SVN Checkout a WordPress plugin

SVN, or Subversion, is a version control system similar to Git that can be used via the command line, or one of numerous GUI applications, such as Tortoise SVN or SmartSVN. In this guide, I will use TortoiseSVN software to checkout a WordPress plugin. Step 1. First, download and install TortoiseSVN software: https://tortoisesvn.net/downloads.html Step 2. After installation, you … Read more

MySQL Process List WordPress plugin - View current MySQL Processes in WordPress

View current MySQL Processes in WordPress

MySQL Process List is used to display currently active MySQL connections. It can be useful to view current queries, detect sleep connections, and if some connection limits are reached. If on your hosting server, you have access to the terminal, you can u list MySQL processes using the command: Here is a simple WordPress plugin … Read more

Delete unused images in WordPress using WP CLI - Delete unused images in WordPress using WP CLI

Delete unused images in WordPress using WP CLI

This small script uses a for loop to delete one post ID at a time, it will go through the database and list all media files uploaded in the provided data range that are not used inside posts. Change the date range according to your needs.

WordPress Backup Plugins Benchmark - WordPress Backup Plugins Benchmark

WordPress Backup Plugins Benchmark

I’ve tested the most used WordPress backup plugins and compared their compression level and backup&restore speed. The website on which I performed the tests is a WP blog (pcx3.com) that has 2.7 GB in files and database size is 130.8 MB Tested plugins: New plugins might be added later on. 🙂 Spoiler alert – the … Read more

Reinstall all WordPress plugins using WP CLI - Reinstall all WordPress plugins using WP-CLI

Reinstall all WordPress plugins using WP-CLI

Here is a convenient WP-CLI command that I use when cleaning hacked WordPress websites in order to reinstall all plugins from WordPress.org It consists of two commands: get a list of all active plugins, then force reinstall for each plugin. To reinstall all WordPress themes in the same manner use: