HoganHost blog

[email protected]

Cpanel

How to Disable ONLY_FULL_GROUP_BY in MySQL Using SSH

                  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

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 »

How to upgrade from CentOS 7 to AlmaLinux 8 with cPanel ELevate

              Introduction This article provides the steps needed to upgrade CentOS 7 to AlmaLinux 8 using cPanel ELevate. Upgrading the OS can cause data loss or catastrophic system failures. Backups should be made and stored off-server before attempting an upgrade. Procedure Backup your accounts. Access the server’s command line as …

How to upgrade from CentOS 7 to AlmaLinux 8 with cPanel ELevate Read More »

Enable/Disable PHP’s allow_url_fopen using Cloudlinux Selector in cPanel

                      Hola we will work you through on how you can use CloudLinux Selector to enable/disable the allow_url_fopen directive in cPanel. 1. Firstly log into your cPanel account. 2. After that go to the Software section and click the Select PHP Version.       3. Then Click on the Options menu. …

Enable/Disable PHP’s allow_url_fopen using Cloudlinux Selector in cPanel Read More »