After setting up a MySQL user’s account and after Setting up the PHP / MySQL Site Definition in Dreamweaver now we are going to have a look at the process to create a MySQL database connection with Dreamweaver. After finishing the defining part you should approach the following MySQL connection dialog box in Dreamweaver.

Connection Name: choose your desired name
MySQL Server: mysql.host.co.in
User Name: Your Username (i.e. Admin)
Password: *********
Database: Here you can directly enter the name of your database or select it from the list displayed of MySQL databases which currently exist on the server.

Note: It’s necessary for the MySQL Server field to enter localhost if PHP and MySQL are running on the same machine.

In a few circumstances you may have to connect the MySQL Database from the local machine to web hosting server, following is the script you can use for the same. Remember you need to have the following information with you

1. Database URL and
2. Java applet – ‘com.mysql.jdbc.Driver’ – to connect it.

Now you can use the following script to connect MySQL database which is hosted remotely.

<!- Database connection settings ->
<property name=”connection.driver_class”>com.mysql.jdbc.Driver</property>
<property name=”connection.url”>jdbc:mysql://localhost[serverIP ]/database_name</property>
<property name=”connection.username”>databses_user</property>
<property name=”connection.password”>password</property>
<!- configuration pool via c3p0->

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

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.

Cloud Hosting services are the new innovative type of web hosting services. This hosting type is based on virtualization technology. There are a number of features and benefits with cloud hosting services which make it different than the typical web hosting types. Cloud computing involves the interaction of multiple virtualized resources. Cloud servers are interconnected to each other in such a way that they can share the data as per the demand from visitors to a particular website. In cloud technology resources required for your website are spread among multiple physical servers so that your website does not remain dependent on a single physical device during peak hours when it has to face heavy loads of traffic. Thus cloud technology made it possible for the websites to achieve highest level of performance supported by the provision of multiple web servers and the resources required are balanced with a combined infrastructure without considering any webmaster at individual level.

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‘