Some server administrators want to restrict the number of user connections to MySQL. There needs to be a consideration of how busy a site may be and how many MySQL connections are needed. A busier site may need 25 connections and ones less active may only need 5. Just use this setting to be able …
How to restrict the number of MySQL connections by users in Cpanel using SSh Read More »
In this guide, we’ll show you how to make changes to your database settings in the MySQL my.cnf file. For example, you may need to increase the number of max_connections or the query_cache_size value for your server. To do this, you simply log in the server via SSH and edit the my.cnf file using an editor such as Nano. This article will explain the …
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 …
Nowadays, the majority of spam emails have fake data in the ‘from’ field. Spammers and fraudsters use special tools to send their mail on behalf of the real owner of their e-mail address. To reduce spam, you can use just two records in your domain name …
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 »
