Working With cPanel | XonHost Knowledge Base

Is it possible to use a Postgre database for application installation?

It is possible to use a PostgreSQL database for all applications that support this database type. The installation is not in anyway different from installation using a MySQL database. You just need to specify the database type you are using. … Continued

How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases’ tables optimized. Fortunately, making this optimization is quite easy when using the phpMyAdmin tool available in cPanel. To perform the optimization, log in to your phpMyAdmin and select the database whose tables you … Continued

How can I download my Softaculous backups?

The Softaculous auto installer allows you to create/restore backups of your applications directly from the web interface. You can also download your backups via your web browser following these step: Access your cPanel and follow the link to Softaculous. From the top right … Continued

How can I create an additional site on my hosting account?

In this case what you need is called an addon domain slot. In order to have an entirely new, additional site on the same web hosting account, you should proceed as follows: Make sure that your hosting account allows the Addon domains functionality. At … Continued

How to create custom mail filters

You can create custom mail filters from cPanel -> Mail -> User-Level Filtering. In case you wish to create a custom mail filter for all of your email accounts you should access the Account-Level Filtering section. For detailed instructions please check our tutorial here.

How to create a Postgre user?

In order to create a PostgreSQL user you should go to your cPanel -> PostgreSQL Databases interface. In the Add New User form enter the username and password. Note that the username will always include your cPanel username as a prefix. Then you can … Continued

What is the information_schema database?

In MySQL version 5.02 and above there is an additional database called information_schema. This database is available inside the cPanel -> phpMyAdmin tool and provides access to the database metadata for the corresponding user. information_schema is the database where the information about all the … Continued

How to change the language in Softaculous?

In order to change the language in Softaculous please follow these steps: Access your cPanel and follow the link to Softaculous from the “Software/Services” tab. From the top right menu choose the Edit Settings button. On the new page you will see a list of all … Continued