cPanel Hosting

How to delete a table in a database with phpMyAdmin

First, you need to Login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)
Locate and click phpMyAdmin under the Databases section.

 

 

You will be redirected to the phpMyAdmin page where you can find the different databases from your server.
Select the database and locate the table you wish to delete from the left hand side of the page.

 

 

How to set up email filtering with SpamAssassin

First, you need to Login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)
To set up an email filtering with SpamAssassin in cPanel. You will need to create a Spam folder within your webmail.
Locate and click on Email Accounts under Email section.

 

 

You will be redirected to the Email Accounts page, then just select the email account you wanted to create Spam folder and click Access Webmail.

 

 

Choose which email clients you wish to use from the 3 as seen on the image below.

How to repair MySQL databases and tables using phpMyAdmin – cPanel

Sometimes, you may encounter issues on your MySQL databases. When it shows error messages regarding your database or tables, you can try to check and repair these problems using the phpMyAdmin tool.

First, you need to Login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)
Locate and click phpMyAdmin under the Databases section.

 

 

You will be redirected to the phpMyAdmin main screen that will show all your databases on the list.
To check or repair a database, select the database you wish to check on the list. The tables will then show up on the center part of the screen.

How to reset your email password – cPanel

First, you need to Login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)
Locate and click on the Email Accounts under the Emails section.

 

 

You will then be redirected to the Email Accounts where it will show you the list of email accounts you have in your server.
From there, click on “Password and Authentication” button for the email account you wish to change the password.

 

 

After that, you will be asked to enter your preferred password.

 

How to set up email forwarding – cPanel

First, you need to Login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)
Locate and click on the Forwarders under Email section.

 

 

You will then be redirected to the Forwarders main screen and will see the Create an Email Account Forwarder, Email Account Forwarders and Forward All Emails for a Domain sections.

 

 

To create and Email Account Forwarder, kindly click on the Add Forwarder button.

 

How to use .htaccess to force SSL on your website

Forcing an HTTPS (SSL) Connection on your website is one of the things that you can do with an .htaccess file. This encrypts the connection between your browser and the web server. You require an SSL Certificate for this to work. To know more about SSL Certificate, please click here.

To create or edit an .htaccess file, you need to login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)

Locate your .htaccess file and edit to add the SSL rule to the file.

Add the following lines within the .htaccess file in your website’s root folder.

How to view shared web hosting server usage – cPanel

Login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)

To view the current resource usage:
On the right column of the page you will see the Statistics Section.
Scroll down and you will see your current server resource usage.

 

To view the resource usage history:
Locate and click on the “CPU and Concurrent Connection Usage” under the Metrics section.

 

 

You will then be redirected to the Resource Usage Overview page. If your website did have issues it will show up here, but if not just click on the Details button to view the resource usage you wish to see.

How to create a wildcard subdomain – cPanel

Another very useful cPanel feature is the Wildcard Subdomain. This allows you to direct non-existing subdomains to a specific folder within your server.
They act as a blanket location, so that if a user is trying to access a non-existing subdomain they will be redirected to a page you wanted them to end up rather than seeing an error on page.

To create a wildcard subdomain:

First, you need to login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)

Locate and click on “Subdomains” under the Domains section.

 

How to rename a table in phpMyAdmin

First login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)

Locate and click on phpMyAdmin under the Databases section.

 

 

You will the be redirected to the phpMyAdmin page. On the left pane you will see the different databases. Select the database that contains the table you wish to rename.

 

 

Once you selected the database, the screen will show the different tables and it contains.

 

 

How to locate .htaccess file in cPanel

What is an .htaccess file?

 

.htaccess is a configuration file that you can create or edit to control some security settings or behaviour for Apache based websites. This file contains configuration rules and directives, that are being read by the web server. A web server may have multiple .htaccess files but there should be only one per directory for specific websites.

 

To find the .htaccess file on your web server. First, you need to login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)