How to optimize a MySQL database using phpMyAdmin?

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?

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?

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

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?

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?

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?

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
How do I point a parked domain to a specific folder?

How do I point a parked domain to a specific folder?

The simple answer is – you cannot point a parked domain to a different folder. Parked domains are aliases for your primary website and can only point to the public_html directory of your account. However, you can redirect parked domain … Continued
Is it possible to create mail accounts for parked/addon domain?

Is it possible to create mail accounts for parked/addon domain?

Yes, it is possible to create mail accounts for Parked/Addon domains. For this purpose log in your cPanel and go to Email Accounts. Under “Add a new email account” you can specify all details about your new email account along with … Continued
How to create a Postgre database?

How to create a Postgre database?

Creating a PostgreSQL database is a straight-forward process. All you need to do is log in to your cPanel -> PostgreSQL Databases. In the Database Name: field enter the desired database name and click the Create Database button. Note that the database will always include … Continued