Changing password is quiet a regular type of task for many webmasters and the same is also applicable to database administrators also. Here I would like to share the procedure of changing the password of MySQL. Root user is the admin of a MySQL account. Remember that it is different than login to root account of a Linux hosting server.
If it’s your first time you are facing the question ‘How to change MySQL password?’ then the server will not require any password at all to connect as root. You will have to use mysqladmin command at shell prompt as shown following.

$ mysqladmin -u root password NEWPASSWORD

If you have your old password set and want to change it then you will have to use a different following command.

$ mysqladmin -u root -p oldpassword newpass
Enter password:

If you want to change the password of a normal user then again the command is different for that as following.

$ mysqladmin -u user -p oldpassword newpass
$ mysqladmin –user=root –password=’old_password’ password ‘new_password’

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’.

Yes, Host.co.in provides its own Cloud Hosting Services with many great unmatched features. You can experience a new level of performance with the cloud technology based servers provided by Host.co.in. Similar to all other web hosting services provided by Host.co.in, cloud hosting services also come with the guarantee of being the best value for money deals. Host.co.in’s Cloud web hosting services enable you to add or remove the resources without the associated factor of cost consideration.

Maximum Scalability with Resources
This is one of the most important features and also the major reason behind making cloud hosting services different than the other hosting services. A webmaster is totally free to scale the resources as per his own requirements. Without any limitation, he can assign the amount of RAM, Bandwidth, Disk-space and other resources.
Cost Effective – You pay for what you use.
Unlike the regular payment method followed with other web hosting types, a webmaster is not entitled to pay for the resources he has not used, he just needs to bear the expenses for the resources, his website has actually utilized. So far all the costs required for all the web hosting types are concerned, cloud has proven itself to be true value for money ‘web hosting services’.
100 % Network Uptime
Before the arrival of the cloud hosting service it was just a dream for any webmaster to see his website up for all the time, which is not possible with any other web hosting type except cloud hosting. Due to availability of resources on multiple physical servers you need not to face any kind of downtime.
Data Redundancy And Back Up
Cloud technology is known for  it’s high fault-tolerance quality and for achieving data redundancy by making few copies of the data on separate server nodes. In any uncertain circumstances when any software or hardware fails, the virtual server automatically starts to fulfill the resources required to keep the website working. Webmasters are also able to reboot the virtual server manually. This ‘redundancy feature of cloud, also backs up your website’s data so that it can be made available whenever required.
Application Programming Interface (API)
After moving to Cloud technology a website can get better API to any operations needed to run over it.

Yes, We provide a the facility of ‘colocation services’ for your Servers and Hardware. Our colocation services are based on Tier III Data center with high-speed redundant network infrastructure. The charges you need to pay for only rent of rack space, cooling and bandwidth and our colocation services are suitable for business houses who are facing problems to maintain the required infrastructure and environment required to keep the servers running 24 x 7 and extracting the best performance from their hardware components.

You can find more details at : http://www.host.co.in/colocation-services.php

Maintaining the web servers at your own at a private place is a costly affair. Colocation services simply means the services which allow you to move your server hardware to a place called Data Center which are mostly owned by web hosting services providers. Data Center is a place developed specially for maintaining the web servers with the best required infrastructure and environment.

Yes you can do it for any email address which even does not exists. Such type of forwarder is called as ‘catch-all’ or ‘default email address’. As far as you have set any particular email ID the forwarder would only check it and forward the mails without checking its existence.

You just need to set the email ID ‘deletedemailid@abc.com‘ to ‘yourdesiredemailid@abc.com‘

Very similar to Email forwarder the feature domain forwarder comes with almost each web hosting services type and package, the difference between both is in email forwarding you can choose the mails which are from the same domain, but in domain forwarding you can do the same for the emails which are from different domains. Following is the example for it.

In email Forwarding you can forward the emails as abc@yourdomain.com toxyz@yourdomain.com.

But in Domain forwarding you can forward the email as abc@yourdomain.com toxyz@anotherdomain.com.

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.

On a Reseller Web Hosting server the Reseller has to create multiple accounts of his own web hosting clients and WHM is a utility which makes it easy to create these accounts. Following is the procedure to creat an account through WHM with any new domain name.

Login to your WHM

• Click Create a New Account under Account Functions
• Here you will find the window with various text boxes which are to be filled by you
• Enter the Domain Name, Username, Passwords(in both fields) and E-mail in prior text-boxes.
• As there are various packages and plans of hosting services may exists so you also need to select the proper web hosting plan demanded by that particular client.
• After filling all the required field carefully click on ‘Create’
• It will take short time to process the account, after getting created it will be displayed on your screen.

Note :- Nameservers of your domain should be pointing to your reseller account name servers and then within few hours, your hosting account will be enabled.

After you received the email which contains download link of SSL certificate, you need to download it by clicking that link and follow the following steps to configure and activate it in your web hosting account.

Configuration of SSL certificate

• Login to the Control Panel
• Click on SSL / TLS Manager
• Click “Generate, view, upload, or delete SSL certificates” option
• Paste the CSR supplied by the Certificate Authority in the “Certificate Signing Request (CSR)” section
• After the page is loaded, click the “Browse” button and locate the CRT file which is created by the SSL provider. Or if you have highlighted and copied the contents of the CRT file, paste it in the
• Click on the Upload button
• Click the “Go Back” link to return to SSL/TLS Manger

Activation of SSL certificate

• Click on SSL/TLS Manager > Setup a SSL certificate to work with your site. Contact your ISP, if this option is not available.
• From the Domain drop down menu select the domain that uses the Cheap SSL Certificate. The SSL Certificate and the related private key will be fetched by the system.

• Open the Intermediate CA certificate in any plain text editor copy all the certificate content and paste it into the CA Bundle (CABUNDLE) box.
• Click on “Install Certificate.” Keep watch on a message that the certificate was successfully installed.

Verification

After installation, configuration and activation of the SSL certificate it is recommended to verify the processes are carried correctly, you can do this by using online SSL Certificate Checker available on the internet.