cPanel | XonHost Knowledge Base

I am receiving security warnings when I try to access my cPanel area

You may receive security warnings when accessing your cPanel through: https://domain.com:2083 This might happen due to using port 2083 along with your domain name rather than a domain name of type *.sgcpanel.com. The sgcpanel.com domain name is the host used … Continued

Can I access directly Awstats without going through the cPanel?

Yes, it is possible to access your AWStats directly through your domain name. However, doing this requires you to add a script to your site and configure it. In other words you need to manually install AWStats for your domain. … Continued

MySQL optimization using indexes

A database index is a data structure that improves the speed of operations in a table. Every time your web application runs a database query, the database will look through all the rows in your table to find those that … Continued

How can I empty a MySQL database?

You can empty the content of a MySQL database via phpMyAdmin or SSH. We would highly recommend you to create a backup of your database (phpMyAdmin or SSH) prior making any changes to your databases. Using phpMyAdmin This is by far the easiest way to … Continued

How can I create a backup in Softaculous?

The Softaculous auto installer allows you to create/restore backups of your applications directly from the web interface. To create a backup of any of your applications please follow these steps: Access your cPanel and go to Softaculous. From the top right … Continued

How can I set a new domain to point to a subdomain on my site?

In some cases you may want a new domain name to point to a subdomain on your account. For example if you have purchased a domain name and you want it to open an already developed website that is located … Continued

How to access cPanel

You can access your cPanel from your User Area -> My Accounts tab -> Go to cPanel button. This will automatically log you in the cPanel of your account using an encrypted connection. If you need to access cPanel via the non secure port, you … Continued

Where are the server log files for my site?

You can find the raw access logs for your account from your cPanel -> Raw Access Logs. Raw Access Logs allow you to see who has accessed your site without the use of graphs, charts or other graphics. You can use the Raw … Continued

How to reduce the size of a MySQL database

MySQL database size limitations are applied for all shared hosting plans, in order to ensure fair resource usage. The limitations are as follows: StartUp – 500 MB GrowBig – 750 MB GoGeek – 1000 MB If a database on your … Continued

I don’t have enough privileges for creating/dropping databases in phpMyAdmin

Your user does not have enough privileges for creating or dropping databases in phpMyAdmin because of security restrictions. The only way you can add or drop databases is through cPanel’s MySQL manager.