CPanel/WHM CentOS Terminal Utilities

cpanel-centos-terminal-utils.sh

# You can force an update of cPanel if you prefer to upgrade right away. EX:
/scripts/upcp --force

# Revalidate CPanel license
/usr/local/cpanel/cpkeyclt

# MySQL log file
sudo nano /var/log/mysqld.log
sudo tail -100 /var/log/mysqld.log

# MySQL configuration file is at /etc/my.cnf in root SSH.
# Upon making any changes to /etc/my.cnf file, restart MySQL for those changes to take effect.
nano /etc/my.cnf

# Restart MySQL with cpanel script
/scripts/restartsrv_mysql

# Check database for corrupted tables (you'll be prompted for the password)
mysqlcheck -u user -p --check database_name

# Check database for specific table corruption (you'll be prompted for the password)
mysqlcheck -u user -p --check database_name table_name

# How to Add Users to Sudo Group in CPanel/WHM
# https://docs.cpanel.net/whm/security-center/manage-wheel-group-users/
# https://support.cpanel.net/hc/en-us/articles/360048959754-How-to-create-sudo-users
# https://www.unixtutorial.org/how-to-use-visudo/

# List installed packages 
yum list installed

# Filter by keyword (e. g. find out if package ghostscript is installed)
yum list installed | ghost*

# This file contains the error logs for webservers and CGI Applications.
tail -100 /var/log/apache2/error_log

# How to fix SoftException in Application.cpp error message in Apache logs
# https://support.cpanel.net/hc/en-us/articles/1500009376861-PHP-website-error-500-Apache-error-log-reports-SoftException-in-Application-cpp-

# PHP error log
tail -100 /home/user/logs/website_tld.php.error.log