How to Create a Database Using cPanel API

Log into your server via SSH. Run the following command to create the database: uapi –user=exampl3 Mysql create_database name=db_name NOTE: Be sure to replace exampl3 with your actual cPanel username and db_name with the actual name you would like to give to the database. Run the following command to create the database user: uapi –user=exampl3 Mysql create_user name=db_user [email protected]$w0rd123! NOTE: Be […]

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