• For cPanel Shared hosting customers Host.co.in’s shared servers come with pre-installed firewall which is reliable and up to the mark when compared to industry standards.
• For VPS Hosting customers, no hardware firewall can be installed as the VPS server hardware is shared virtually by more than one individual, but still you can choose any software firewall of your own choice.
• Dedicated Server Hosting customers have the full freedom to choose and customize firewall option according to their own choice.

For a webmaster it is one of the regular tasks to shift files and folders from one directory to another. If you are a webmaster using cPanel Hosting which comes with cheap web hosting plans, then it’s an easy task to move files and folder from one directory to another. You just need to follow the following instructions.

• Log in in to your cPanel account, here your can find ‘File Manager’ Icon under Files category.
• Click on it and You will come to one message window providing you the following options

1. Home Directory
2. Web Root (public_html/www)
3. Public FTP Root (public_ftp)
4. Document Root for (For Exchanging Data among sub-domains created on a main domain)

• You need to select the appropriate option to find the destination of file or folder you need to move from and click ‘Go button. (’Home Directory’ contains all the sub-directories so you need to follow longer path if your went through it)
• After reaching to your destination file or folder you can find all editing options at the top of the window including ‘New File’ ‘New Folder’, ‘Copy’, ‘Move File’, ‘Upload’, ‘‘Download’, ‘Delete’ etc.
• As you want to move the File, you first select it and click on ‘Move File’ now it will ask you the destination folder where you want to move the file, just provide it and click on ‘Move File(s)’ button.

That’s it you can check for the file you have moved in the respective folder.

In previous post we saw how to change MySQL password using mysqladmin command at shell prompt. But there is another way to do it by updating the MySQL database.  As usernames and passwords are stored in a user table in MySQL database so you can directly change password of any user by following the below given method.
First you need to login into MySQL server and type the following command

$ mysql -u root -p

For using MySQL database you need to type the following command

mysql> use mysql;

Suppose that you want to change password of a user having username ‘XYZ’, then type the following command

mysql> update user set password=PASSWORD(“NEWPASSWORD”) where User=’XYZ’;

After doing these changes it’s recommended to reload privileges before you quit so type the following command.

mysql> flush privileges;

Now to exit MySQL use following command

mysql> quit

cPanel by default comes with the inbuilt scripts, which has the ability to backup or restore your cPanel account. Following are the commands given to run these scripts.
Following is the command which creates the backup of a cPanel account.
/scripts/pkgacct
Following is the command which restores the taken backup
/scripts/restorepkg
Both these commands should be run as root and while restoring a backup you also need to take care to be in the same directory in which the backup is stored.

‘Awstats’ is one of the most important utility in a web hosting account’s cPanel. One can analyze the website’s statistics with it. It comes as a free utility with cPanel Hosting. Many web hosting services providers provide it as a paid option with other web hosting types services like vps hosting or Dedicated Server Hosting. Following is the procedure to activate ‘Awstats’ with your hosting account.

• Log in to your cPanel with Username and Password
• Search for ‘Choose Log Programs’ under ‘Logs’ Category and click on it.
• Here you can find ‘Awtats’ option beside your domain name, click on it.
• Now go back to the previous screen where you will find ‘Awstats’ logo. You can click on it to use it.

Note:- It may take time until the completion of the cycle of 24 hours to appear the statistics in ‘Awstats’.

Email Forwarder is an important utility comes with web hosting services plans. It makes it possible to forward the copies of mails received at a particular email address to another desired email address. Most of the time you do not want to use two email Ids separately as it is a time consuming factor.

For example one has used an email ‘abc@yourdomain.com’ and later one he left it and started using ‘xyz@yourdomain.com’, but while using it he do not want to loose any emails coming on the abc@yourdomain.com the he can us email forwarder to forward all the emails coming at abc@yourdomain.com to xyz@yourdomain.com

One copy of each email is forwarded to second email saving time to check separately by logging into the first email. This features comes with almost all the hosting types right from basic cPanel Hosting to Dedicated Server Hosting.

For generating certificate signing request all the cPanel shared hosting customers will not have direct access. Web Host Manager is the central control from where the CSR can be generated and installed to the issued to the client who has requested it.

Follow the below mentioned steps to generate a CSR certificate

• Click on the Link ‘Generate a SSL certificate and Signing Request’ which is found in the SSL/TLS menu.
• Provide a email address at which the certificate to be received.
• In the ‘Host to make cert. for’ Provide the domain for which the SSL is to be created.
• Provide other details like Country, State, City, Company Name, Company Division, and Email fields. Make sure to provide password and then click on ‘Create’.

After completing the above procedure you will receive an email at the email address you had provided, you can download the certificate by clicking the link provided in this email.

SSH keys are the great utility for cPanel shared hosting clients. These SSH keys play important role while allowing a specific computer system to access your website’s information through a SSH session.

Find the ‘Generate a new Key and Import Key links and follow the following the steps.

• Click the ‘Generate a new key icon.
• Fill all the required information properly. This is to be done by keeping in mind your requirements as RSA keys creates a faster confirmation of identity and DSA keys are known for fast key generation and signing times.
• Choose a key size using the pull-down menu. While doing this you should know that a bigger key size provides more security but will take more time for authentication. So you need to decided the proper combination of security level and time consumed for authentication.
• Click on Generate Key for the generation of new SSH key and it will get automatically installed on the web server.

As free emails are provided with many web hosting packages right from cPanel shared hosting to Dedicated Server Hosting, many webmasters prefer to use their emails which are created at their own website with their own domain name, this also provides them a little bit extra security. Following is the process of redirection of ‘yourdomain.com/webmail’ to ‘mail.yourdomain.com’

• Login in your cpanel
• You will find ‘Subdomains’ under ‘Domains’, click on it
• Now you will find ‘Create a Subdomain’ with name mail.domain.com
• Now click on ”Manage Redirection’ In Subdomain section.
• Type ‘mail.yourdomain.com’ in the text box, this will redirect yourdomain.com/webmail to your desired mail.domain.com
• Click on Save and exit.

In wp-admin for retrieving password one need to click on ‘Lost your password?’ which appears at login screen. After clicking it you will have to enter either your username or e-mail ID which is verified in wordpress database and if found then new password is forwarded to your email address which you used for registration.

As the above procedure is a little bit lengthy and time consuming one there is another one method can be used for the same. By using particular instances you can access admin area. By using phpMyAdmin which is a utility provided with cPanel Hosting package, one can manage his wordpress database. After accessing the phpMyAdmin it is necessary to select the database which is used by your website. Click on that database and you will find multiple table inside it. Find SQL tab which is located at the top of the navigation bar. You need to type following SQL query in the field available.

UPDATE `wp_users` SET `user_pass` = MD5( ‘new_password‘ ) WHERE `wp_users`.`user_login` = “your_username”

Replace ‘new_password‘ and “your_username” in the above query with your desired new desired password and your username respectively. After you typed the query accurately, click on the GO tab, this will submit your query. If you have done the above work successfully then you should be able to login in to your wordpress admin area.

Following are the steps to install phpBB through cPanel using softaculous.

• Login to your cPanel web hosting account by using your username and password.

• Click on the ‘Softaculous icon, which will carry you to newer screen where you will see ‘phpBB’ listed under the forums to the left side.

• Click on the phpBB and you will see the overview page of particular phpBB Version.

• Find the ‘Install’ tab and fill all the required details in the form such as Protocol, Domain, Directory in which phpBB is to be installed, Database name etc.

• Now find the ‘Install’ button at the bottom and click on it, your installation will get started and you will receive the message “Congratulations, the software was installed successfully.” after successful completion of it.

Now you can login into your phpBB control panel through the url provided at confirmation page and arrange the setting as required.

AWStats is short form used for Advanced Web Statistics. AWStats is powerful and efficient log analyzer which provides advanced web, ftp, mail and streaming server statistical reports from the data stored in the server logs. The data is graphically represented in easy to read and understand web pages.

AWStats is designed keeping in mind flexibility for users, it can be run or used through a web browser CGI or directly from the operating system command line. AWStats is free software application distributed under the GNU General Public License. As AWStats works from the command line as well as a CGI, it is compatible with web hosting providers which allow CGI and log access.

Reports generated by AWStats include a wide range of information on your web site usage, some of the key features are mentioned below:

• Its provides a count of Number of visitors and the number of Unique visitors.
• It displays the visit duration and visits.
• List of Authenticated users and latest authenticated visitors
• Usage bifurcated by Months, Days and Hours of the day
• Domain names and Countries
• Provides details of Most viewed, entry and exit pages
• Displays Web Compression Statistics
• Visitors Browser information is also provided
• Search Engine crawler and Robot visit information
• Tracking of downloads like PDF, compressed files and others can be done easily
• Search engines, Keywords and Phrases used to find your website
• HTTP Errors if any are displayed
  
• The number of times your site is added to Bookmarks / Favorites can be tracked.