Introduction MySQL governor is provided by CloudLinux and allows the system administrator to set LVE limits for MySQL users. Procedure 1. Install the mysql-governor package: yum install governor-mysql 2. Next the MySQL or MariaDB version will need to be selected: /usr/share/lve/dbgovernor/mysqlgovernor.py –mysql-version=mariadbXX mariadbXX will be replaced with …
Today, in this tutorial we will illustrate the procedure to enable PDO PHP extension for all PHP versions in cPanel/WHM. In this tutorial, we will learn the following: #1. How to Enable PDO PHP Extension in WHM? To enable PHP extension in WHM, follow the below mentioned steps. Login to WHM as root. Navigate to Software section and …
How to enable PDO PHP extension for all PHP versions in cPanel/WHM? Read More »
MySQL is a crucial component of many web applications, responsible for managing databases and ensuring smooth data operations. In the event of issues or performance optimizations, restarting MySQL becomes necessary. Here, we’ll explore how to restart MySQL using both WHM (Web Host …
Understanding the Scripts Executed During /scripts/upcp in cPanel Servers In the realm of web hosting management, cPanel stands out as one of the most popular control panel solutions, offering a suite of tools that streamline server administration tasks. Among its many features, cPanel includes an …
What Scripts Are Executed When /scripts/upcp Runs Read More »
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 »
Holla we will work you through on how to monitor your mysql process using ssh command remember you need a root priviledge of your vps or dedicated server to perfrom this action. Why Monitor MySQL Usage? Understanding MySQL usage provides several advantages: Performance Optimization: Identifying resource-intensive queries or operations helps optimize database performance. Resource Allocation: …
How do I empty a directory (delete all files) under Linux / Unix without deleting directory itself? You can use the following commands: [a] rm command – Delete one or more files or directories. [b] find command – Find and delete all files from a specific directory. …
