The SELECT statement is used to select or fetch data from a your MySQL Database. It’s the most common type of query issued to a database. There are many ways to query a database, but were going to focus on the SELECT statement...
By default on Linux servers SSH runs on 22 port. We can change the default SSH port for Linux server as an added security measure. NOTE: Before changing the SSH port makes sure the new SSH port does not conflict with any known, used or blocked...
Most interactive websites nowadays would require a user to log in into the website’s system in order to provide a customized experience for the user. Once the user has logged in, the website will be able to provide a presentation that is...
Into this tutorial we will learn how to identify a user account or who is logged into system with commands like who or who am i. If multiple users use a single system, then everyone may have their own user account. At this time, it will be helpful...
Virtualizor has a license verification function inside: /usr/local/virtualizor/main/functions.php content is encrypted, but in older versions, it wasn’t, so to bypass license verification you can simply replace the current file content with...
We can enable chroot in the recovery console, so customers can start essential services and use it to generate MySQL database backup.
A few months ago I was approached by blank from blank on Fiverr regarding “WordPress Development” job, but actually, it had nothing to do with Development, but rather just building PBN’s. For those of you that don’t know...
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(...
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...
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...