install cpanel centos 7

How to install cPanel/WHM on CentOS 7 and Configuration Guide

How to install cPanel/WHM on CentOS 7 Installation Requirements A clean fresh minimal installation of CentOS 7 server. Minimum of 1 GB RAM (but 2 GB recommended). At least 20GB of free disk space (but 40 GB recommended). A valid cPanel license. Standard hostname (FQDN or Fully Qualified Domain Name) Perl Before we proceed to the […]

Continue Reading

How to resolve “ORDER BY clause is not in SELECT list” caused MySQL 5.7 with SELECT DISTINCT and ORDER BY

If you have control of the server and you are running legacy code you can’t easily change, you can adjust the SQL mode of the server and remove “only_full_group_by” either for the duration of boot, by running the query SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”));’ or by adding sql_mode=” to your my.cnf file. Obviously its better to change your code if […]

Continue Reading

change Apache Port Number on a cPanel Server

Apache is a widely-used web server that is distributed under “open source” license. By default, Apache uses port 80 and secure port 443. You can change the port through WHM or from the cli. Follow the below Steps to change Apache port number through WHM. 1) Login to WHM through https://yourserverIP:2087 2) Go to ‘Tweak Settings’. […]

Continue Reading

Mysql Consume High Server resource Then Optimization of MySQL settings

Why does MySQL consume high memory? Application software like Python, PHP, JAVA threads utilize more memory when configured improperly or un-optimized queries, complex coding, etc. Due to improper configuration of MySQL, it leads to inefficient memory or wastage of memory. If the memory is lower than, required by the processes on the server. Resolutions to […]

Continue Reading

What is MultiPHP Manager in latest Cpanel by Ryan Burke

Multiphp Manager is one of the major improvements introduced by Cpanel team with Easy Apache 4. In order to use MultiPHP Manager you will need to upgrade the Easy Apache version to 4. The MultiPHP manager allows users and administrators to select the server default and per-domain default PHP versions. So though you have running […]

Continue Reading

Check and Repair a Corrupted MySQL Database Table Using SSH?

Please refer the following steps: a)     Login to your MySQL server using Secure Shell (SSH). b)     Enter the following command at root prompt: mysqlcheck -r [database name] Where, mysqlcheck is the command to check the database, -r is the command to repair the corrupted tables. Replace the [database name] with your actual database name. Please note that MyISAM is a default storage engine […]

Continue Reading

cpanel whm service restart command list via putty or ssh

Here is the command list for use in putty on ssh connection. this is the general command which use every time in cpanel hosting service httpd restart service httpd start|stop|restart|status service mysql restart # service network stop # service network start # service network restart /usr/local/cpanel/cpkeyclt /etc/init.d/crond restart /etc/init.d/crond restart /etc/init.d/syslog restart service nginx start […]

Continue Reading

FFMPEG Linux Centos server for all latest version centos 7.xx

Here is working ffmpeg for all linux centos operating system . all types of converter will work in server. libavcodec – an audio/video codec library libavutil – utility library to aid portable multimedia programming libavformat – library which provides framework for multiplexing and multiplexing video/audio and subtitle streams libavfilter – library which enhances a generic […]

Continue Reading