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

Error “Your IP address has changed. Please log in again.”

You can receive this error when your ISP provided you with a dynamic IP. To resolve the issue you can try to:  use cPanel proxy link use http://cpanel.domain.tld link use a VPN connection ask the current ISP to provide you with a static IP The cPanel proxy links on Shared Hosting servers look like in the following way:For Shared Hosting […]

Continue Reading