MySQL’s ONLY_FULL_GROUP_BY mode is a SQL mode that, when enabled, requires all columns in the SELECT clause to be either aggregated or included in the GROUP BY clause. While this mode helps enforce strict SQL standards and prevents potentially ambiguous queries, it can sometimes interfere with …
How to Disable ONLY_FULL_GROUP_BY in MySQL Using SSH Read More »
Reset File and Folder Permissions and Ownership for a user account in Cpanel Use this script to reset the permissions and ownership of files and folders on a Cpanel user account. This script will iterate through a users Cpanel account files in public_html and set the folder to 0755 and files to 0644. Why Use …
Reset File and Folder Permissions and Ownership for a user account in Cpanel Read More »
MyTop is one of the best MySQL monitoring tools available, written by a MySQL guru, Jeremy Zawodny. Its vital for monitoring your MySQL health, especially in a shared hosting environment. Installation on a CentOS (for cPanel) server is quite straight forward with this guide. First off, …
cPanel is a widely used web hosting control panel. As it is easy to use, a majority of hosting providers offer it with Shared Hosting, Cloud Hosting, VPS hosting, Dedicated Servers, etc. While WHM (Web Host Manager) admin panel is used to manage multiple cPanel-based websites. Wondering how to install it …
This guide explains how to enable Analytics feature from cPanel. cPanel Analytics is a feature that allows website owners to track and analyse traffic to their websites. It integrates with Google Analytics, a popular web analytics service, and makes it easy to enable tracking and view website statistics directly from within the cPanel control panel. …
cPanel is a powerful web hosting control panel used by millions of website owners and hosting providers worldwide. It provides an intuitive interface for managing various aspects of your web hosting environment. However, there may be situations where you need to downgrade the cPanel minor version due to compatibility issues or …
The following guide will give you an overview on how to configure additional IPv4 addresses on the most popular operating systems. We designed this article to be helpful not only for our HOGANHOST customers, but also for people using any other provider. Getting Started As an example, we will use 192.51.100.10 as …
Imagick is one of the most required add-ons to enable image manipulation on your Website. Please note that pocel( ) and ini_set PHP extensions should be allowed in order to install ImageMagick. Following are the steps to install ImageMagick on your WHM/cPanel. Install ImageMagick PHP module in Cpanel Server To install ImageMagick …
