database

WHM/cPanel Logs: Access, Apache, Email, Error, FTP, MySQL,

cPanel logs Access logs and user actions /usr/local/cpanel/logs/access_log Account transfers and misc. logs /var/cpanel/logs Auditing log (account creations, deletions, etc) /var/cpanel/accounting.log Backup logs /usr/local/cpanel/logs/cpbackup Brute force protection (cphulkd) log /usr/local/cpanel/logs/cphulkd.log Cpanel dnsadmin dns clustering daemon /usr/local/cpanel/logs/dnsadmin_log Cpanel taskqueue processing daemon /usr/local/cpanel/logs/queueprocd.log DBmapping /usr/local/cpanel/logs/setupdbmap_log EasyApache build logs /usr/local/cpanel/logs/easy/apache/ Error log /usr/local/cpanel/logs/error_log Installation log /var/log/cpanel License updates […]

Continue Reading

How to empty a MySQL database via SSH or phpMyAdmin

There are two ways to empty a MySQL database: via phpMyAdmin and SSH. NOTE 1: By default, SSH access is disabled on all our shared servers. If you need SSH to be enabled, contact our Hosting support via Live Chat or submit a ticket to the Hosting Support department. NOTE 2: We recommend making a backup of your database before proceeding with any changes. […]

Continue Reading

PostgreSQL Installation or Upgrade and restore previous version in cpanel

PostgreSQL Installation or Upgrade If you wish the installation, upgrade, and configuration of the PostgreSQL on your server, then follow the given steps. Use /usr/local/cpanel/scripts/installpostgres commandTh This command upgrades or installs PostgreSQL. ConfigurePostgreSQL interface of WHM must be accessed through WHM >> Home >> SQL Services >> Configure PostgreSQL In case PostgreSQL does not exist […]

Continue Reading

How To Enable Remote Access to MySQL via SSH in linux or unix server

Once you log into your server via SSH, the steps are as follows: 1. Edit the MySQL configuration file, to tell the MySQL server to listen on all available IP addresses. We recommend using nano if you are unfamiliar with more advanced text editors such as vim. To install nano, you can run the following […]

Continue Reading

cPanel will stop working properly .Some basic problems are

cPanel is the commonly used web hosting control panel which is a simple and easy interface to create E-mail accounts, fully functional domain, child domain, database and file transfer protocol users. Each cPanel account controls the settings for that particular account. Let’s now explore the errors you encounter in cPanel and how to rectify it. […]

Continue Reading
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