ip 540x304 - 📍 Display User's IP Address 🌍 in WordPress

📍 Display User’s IP Address 🌍 in WordPress

Add the following code to your active theme’s functions.php file and then add this shortcode [show_ip] anywhere on your website where you want the IP to display. /** * IP shortcode*/ function get_the_user_ip() { if ( ! empty(...

git 540x304 - SVN vs Git commands

SVN vs Git commands

Back in 2017 when I built my very first WordPress plugin I had trouble uploading it to WordPress.org because I’ve never used SVN before. As a Git guy I’ve never worked with SVN before and at the time I was searching all over the web for...

Cover Image by MilesAndryPrower on DeviantArt

☑ Optimize a MySQL database

If you have deleted a large part of your table or updated many variable length rows, you should consider running the optimize command. If you want to quickly generate the optimize commands for every table in you database, executing the...

what is cpanel 540x304 - ⚠️ cPanel error: mysql database size 0MB

⚠️ cPanel error: mysql database size 0MB

You may see the mysql database size as zero in cPanel >> ‘Mysql Databases’ option, though the databases contains tables and data. In order to include the size of the databases while displaying disk usage in cPanel/WHM, perform...

mongodb - SQL to Mongo correspondence table

SQL to Mongo correspondence table

This list is the PHP version »SQL to Mongo correspondence table (there is a more general version in the official MongoDB manual). SQL queryMongo query statementCREATE TABLE USERS (a Number, b Number)Implicit creation...

plesk 540x304 - Find Plesk Version

Find Plesk Version

To find Plesk version, login to the server and run

plesk version

plesk version

phpmyadmin limit 540x304 - Increase PHPMyAdmin upload limit in cPanel

Increase PHPMyAdmin upload limit in cPanel

To increase PHPMyAdmin upload limit in cPanel edit the following file:

nano /usr/local/cpanel/3rdparty/etc/php.ini

and change the following values:

upload_max_filesize = 150M
post_max_size = 150M

apache 540x304 - How to Auto-Renew SSL on Password Protected 🔒 site Apache ✔️

How to Auto-Renew SSL on Password Protected 🔒 site Apache ✔️

On a website that is password protected using Apache basic authentication to auto-renew SSL we need to make the .well-known folder to be accessible without password. Password protected Apache website: <Directory "/var/www/html/"> AuthType...