Reseller Hosting vs. VPS Hosting

Reseller hosting is a form of shared web hosting that allows users to create and sell off their own web hosting packages and at the same time allows them to create their own client accounts for their web hosting customers; VPS hosting is a form of shared hosting to an extent, but to many it is regarded as a form of dedicated hosting because of the way in which a VPS is able to function. Although reseller hosting is designed specifically for the hosting of multiple client accounts and websites, VPS hosting servers are able to offer users a lot more if they have enough knowledge to make the most of their VPS server. The difference in price between a high end reseller hosting account and a low end VPS hosting server, and because of the freedom that you have with a VPS server you may be tempted to purchase one purely based on price. As a beginner you will be more suited towards reseller hosting since the server administrator is taken care of by your web hosting provider, and you are unlikely to have to pay any extra charges for things such as control panels and support. VPS servers on the other hand are suited more towards experienced professionals who are able to manage servers to an extent that they are secure.

VPS hosting is generally powered by the Virtuozzo server virtualization daemon which is used by many web hosting providers to offer both Windows and Linux VPS hosting solutions to customers. Reseller hosting accounts tend to be hosted on the same server as shared hosting accounts therefore meaning that you don’t need to worry about server management. In terms of control panels you will find in most cases that you will have to pay extra in order to have a control panel on your VPS server, whereas control panel access comes provided as standard with reseller hosting.

Advantages

In terms of advantages you may find that those of VPS hosting will outweigh the advantages of reseller hosting, however at the end of the day it is your own personal preference and previous experience that should help you decide on which hosting solution will be better for your needs. VPS hosting offers you freedom that have only been available on high end dedicated server, but its the fact that VPS servers offer the same experience but at the lower cost of a dedicated server that draws many businesses and individuals into purchasing them for their requirements. Reseller hosting is the perfect solution for beginners since you can normally count on the support of your web hosting provider to help you out if you face any problems with your web hosting account, and they are also likely to be monitoring the server that you are hosting on in order to make sure that it remains stable. The main advantages that you will get from reseller hosting will include:

• lower costs - by using reseller hosting you are able to lower your overall costs than if you were to use VPS hosting - most reseller hosting accounts tend to be cheaper than VPS servers meaning that you are more likely to get something that suits you within your budget with reseller hosting, if you choose VPS hosting with a budget which is designed more for reseller hosting then you will end up only being able to afford a basic VPS server
• no experience needed - in order to offer their reseller web hosting services, you will find that web hosting companies use a control panel of some sort to enable you as the customer to manage the different aspects of your web hosting account using a web browser - because of this, you will find that you don’t need to have any experience when it comes down to managing servers or web hosting accounts since such control panels are normally very intuitive and management of the server is taken care of by your web hosting provider
• full support - since web hosting providers are normally responsible for the management of their shared hosting servers, you will find that you are entitled to receive full support for your reseller hosting account - this means that you can contact your web host to clear up any issues that you may be having with your account, but as an example, it also means that you can have them install applications within your web space for you if needed.

Although a majority of the advantages for reseller hosting services are aimed at beginners who may not necessarily know how to manage servers, the opposite can be said for VPS hosting services since a majority of the advantages are only likely to affect advanced system administrators who know how to manage servers. The main advantages that you will see from VPS server hosting will include:

• dedicated hosting environment - VPS servers are basically dedicated environments in the form of a virtual environment meaning that you can carry out most of the same tasks that you would be able to on a VPS server, the only different being that a VPS is virtual whereas a dedicated server is a physical version - unless you need physical access to a server, you will probably find VPS hosting more beneficial this way
• dedicated resources - since you have your own dedicated hosting environment, you need your own dedicated resources - because of this you will find that when looking for a VPS hosting package, VPS hosting providers are offering VPS servers with different amounts of ‘guaranteed RAM’, ‘burstable RAM’, disk space and bandwidth - it is important that you find out what these different terms mean so that you can get the best deal going
• freedom - with having your own dedicated environment you have freedom that shared hosting isn’t able to offer - this means that you can install any programs of your choice on your VPS which you can then make use of as and when needed - for example you may want to install a specific program to make sure that your website works correctly, however your web hosting provider may not be able to do this for you on a shared/reseller hosting package.

As you can see, both forms of web hosting are able to offer you their own advantages when it comes down to what suits you best. So far we can see that if you are a beginner then you will be more suited to reseller hosting, and if you are a more advanced user or have outgrown your reseller hosting account you will be more suited to VPS hosting. As a startup web hosting provder you may want to consider reseller hosting however because of the low costs involved.

Disadvantages

Both forms of web hosting have their disadvantages, although in the eyes of some one form or the other may seem like the clear choice. VPS hosting can cost a bit more than reseller hosting and because of the current economic situation, some people may be put off from purchasing VPS hosting servers. Reseller hosting services can restrict what you are able to do as a reseller since you will be affected by the security rules that your web hosting provider has put into place on the hosting server. In both cases you may find that getting your neck around how a control panel works may be a bit hard, but once you have learnt to use a control panel you will find that it will benefit you greatly in the future. The main disadvantages that you may find with reseller hosting services could include:

• shared servers - reseller hosting servers contain many hosting accounts that will be a mixture of both shared hosting accounts that have been sold by other resellers as well as the shared hosting accounts of your web hosting provider - this means that the overall performance of a server may not be great, but of course this will depend on the specifications of the hosting server that your reseller hosting account is hsoted on
• account resources - you will find that the amounts of disk space and bandwidth that you will have assigned to your reseller web hosting accounts are far less than you would be able to get on a VPS server - because of this you are likely to reach these limits in a short amount of time at which point you will probably need to upgrade to a VPS server - it may be better for you in the long run to start off with a VPS
• limited applications - in most cases you will find that you are limited as to the applications that are installed on the hosting server - if there is a specialist application which you need to make a website function correctly then you will have no choice but to consider VPS hosting services - most web hosting providers won’t install third party applications on their hositng servers just to benefit one customer.

Although such disadvantages are likely to put you off reseller hosting and sway you more towards VPS server hosting, you should still keep your main requirements in mind as well as your budget since you don’t want to go over the amount you wish to spend. The main disadvantages that you may face with VPS server hosting could include:

• resource over-usage - many VPS hosting servers are hosted on one VPS node, and although each VPS is assigned its own usable amount of RAM, disk space and bandwidth, you will find that the server’s processor is split amongst the multiple VPS servers that are being hosted - because of this it takes just one VPS server to make the entire VPS hosting node crash if there is no CPU power left for any other VPS to use
• cost - the cost of VPS hosting services is normally greater than that of shared hosting packages but less than you would pay for a reasonable specification dedicated server - however, the cost of a VPS server when compared to that of a reseller hosting package can still be daunting for those who may be upgrading from one to the other.

All in all you will find that VPS hosting is worth it if you are able to afford the extra costs and know how to manage a server correctly. On the other hand, reseller hosting packages are more suited to those with smaller budgets and who may not know how to manage a server.

In conclusion, reseller hosting packages have their advantages but the overall package architecture is designed more for users to may not know how to manage a server correctly. Since web hosting providers take full responsibility for their reseller servers they will be able to offer you full support for your reseller hosting account. VPS hosting on the other hand requires that you know how to manage a server; although you can purchase fully managed VPS hosting plans, it is still a good idea to have a good range of server management skills.

Error

PHP Parse error: syntax error, unexpected T_STRING

Please add the following line in the php_flag short_open_tag X in the .htaccess file and
short_open_tag = X in the php.ini file under the clients folder on the suexcec server and then check .

error error : [notice] child pid x exit signal File size limit exceeded (25.)

You are getting above error when any file get exceeded the limit of 2GB so to get it resolved you need to emptied that file.

check the files from /var/log or /usr/local/apache/logs/

Advantages and Disadvantages of Dedicated Server Hosting

Dedicated Servers are seen as the best type of web hosting for people who are running large resource intensive websites that receive many visitors, as well as for people and businesses who need to be guaranteed a stable service that is more reliable than other types of web hosting, such as shared website hosting and VPS Hosting; this is because a dedicated server is yours only, meaning that you are not sharing it with anyone else, thus meaning that all the resources on the server are for your use only and can’t be used by anyone else, allowing you to ensure that you are able to provide a reliable and stable service. However, dedicated server hosting is out of most people’s price range for the main reason that dedicated servers are relatively expensive to get hold of, since they are physical machines, unlike VPS hosting for example where the servers are actually virtualized on a physical hosting node that is shared; this means that dedicated servers are only mainly used by businesses who have a large budget and want to ensure that their servers are stable, or by people who are running large websites that provide them with enough revenue to be able to justify and cover the cost of a dedicated hosting server.

The Dedicated Server hosting market has seen a boom in recent years, meaning that the overall costs of dedicated servers has been reduced, allowing people who couldn’t previously afford one to purchase one to cover their needs; this means that the overall number of dedicated servers being taken out with web hosts has increased, thus increasing the amount that web hosts have been earning, but also increasing the number of web hosts there are to choose from since many people have seen the advantages of starting a web host and have decided to do so. In order to use a dedicated server, you will need to ensure that you have the necessary knowledge to be able to administrate one with ease, this means that you should choose an operating system for your dedicated server that you are comfortable with during the order process, since getting used to the dedicated hosting environment will be much easier if you are using a familiar interface or system; it is important that you know what you are doing with a dedicated server since in most cases it is up to you to keep the server up to date and secure, to ensure that hackers and other malicious attackers aren’t able to gain access to it and exploit it.

You should also be familiar with the relevant dedicated server terms before purchasing one, so that you know if you are running out of a certain resource or so that you know what a problem is if something happens to go wrong with your server; this is because in some cases the support team of the web host from which you have purchased your dedicated server might only provide you with limited support, meaning that you should know the ins and outs of your server as to avoid any problems with it. You should ensure that what you want to use your dedicated server for is in line with your web host’s AUP (acceptable usage policy), since if any activities or actions that you carry on your dedicated server aren’t in line with it or are affecting the performance of other servers on the same network as yours, then your web host might suspend your dedicated server in order to sort out the issues; in most cases you aren’t allowed to use dedicated servers for free web hosting because of the high risk of system abuse that is involved, and you aren’t allowed to host warez or IRC servers either since warez are deemed as illegal, and in most cases IRC chats are used to discuss illegal activities which is why web hosts don’t allow them in most cases.

Dedicated Servers have many advantages over other types of web hosting, meaning that if you need the utmost reliability then you should consider a dedicated server for your needs, since it is something that should fit the needs of most people; the main advantage is that you aren’t sharing the server or resources with anyone else which is most people’s main reason for choosing dedicated server hosting.

Advantages of Dedicated Server Hosting

Dedicated server hosting has to be the best type of web hosting for anyone, since you are not sharing your server with anyone else meaning that you have complete use of all the server resources; this means that you can allow for your large traffic website to flourish in a dedicated hosting environment. If you run your own small hosting business, then you are also able to ensure your clients a high level of reliability and uptime, meaning that their websites will also be up and available; with other types of hosting you aren’t able to guarantee either of these factors since other websites and accounts could easily affect you.

Dedicated Resources

The main advantage of having a dedicated server is the fact that the server is all yours, meaning that you have complete use and control of the server’s resources since there is no one else on the same server to use them as well; this means that if you run a resource intensive website, or an application or service that requires high specification hardware, you are able to without disrupting anyone else and without anyone else disrupting you meaning that you are able to ensure that your website or server is reliable and always available.

Although with the lower end equivalent of dedicated server hosting, VPS hosting, you are given guaranteed resources that will always be available for your use, but the CPU of the main host node isn’t split between the VPS on the server equally in some cases, meaning that it is a resource which isn’t always guaranteed for your use; however, with a dedicated server you have your own CPU meaning that it is always available for use by you - you also have a choice of CPUs in most cases, meaning that you could have up to 8 CPU cores available for your own use at any time. Like VPS Hosting, you have your own dedicated amounts of RAM and bandwidth which you are able to utilize on your dedicated server; however, with a dedicated server, the amount of RAM that you have is actually physical meaning that you can easily have it upgraded - bandwidth is the same as a VPS server though, meaning that you can only transfer as much bandwidth you have each month - once you have used all your bandwidth up you will have to upgrade your dedicated server by purchasing more bandwidth.

Since your dedicated server is yours, no one else is sharing it with you meaning that the performance and reliability of it isn’t able to be affected by anyone else; the only way that your dedicated server can be affected by other people is if someone attacks the network which your dedicated server is connected to - for example, another server that is connected to the same network as yours might get DDOS’d, which can slow down the entire network, this will affect your dedicated server directly since any external connections to it will be very slow. In most cases, you aren’t provided with any sort of control panel to allow you to remotely manage your dedicated server, meaning that if it crashes you will have to get your web host’s support team to bring it back up again; it is for this reason that it is suggested that you use some sort of external monitoring system so that you are alerted when your server goes down, or when too much of a certain resource has been used.

Root/Administrator Access

Unlike other types of Web Hosting, except VPS hosting, with dedicated server hosting you are able to have root/administrator access to your dedicated server meaning that you are able to install and do anything you want within your dedicated server, allowing you to customize it to the way that you want it to be; this means that if you want to host a website or application on your server that requires you to have a certain component installed or for the server to be configured in a certain way which isn’t possible on other types of hosting, you are able to do so and at the same time are enabling your website to be more reliable by hosting it on a dedicated server.

Root/administrator access is needed on a dedicated server since it allows you to installed the programs that you need to ensure that your dedicated server is secure, and so that you are able to run what you want and use your dedicated server for what you want; you can also carry out custom configurations of certain programs with root/administrator access, meaning that you can easily change the configuration of a certain program if needs be. With root/administrator access, you are also able to easily manage and view the server resources, allowing you to monitor them so that you can take the necessary action if a resource was to get overloaded which could cause the server to crash, which is not something you want since you might not have the ability to restart it yourself; you could also deploy an internal monitoring system so that you easily view and manage your server’s resources without having to be constantly logged into it - this would also mean that you have the ability to view and manage your server’s resources over the internet from any location in the world.

In the case of a Linux dedicated server, you will be given ‘root’ access to it meaning that you will be able to manage it using the ‘root’ account, normally via the means of SSH meaning that you should be aware of the main Linux commands prior to purchase a Linux dedicated server; Linux server administration via the means of SSH is carried out through the use of unique commands, meaning that in most cases a GUI isn’t provided for administration access - however, in some cases a GUI via the means of VNC might be available for your use.

In the case of Windows dedicated server hosting, you will be given ‘administrator‘ access to your dedicated server meaning that you will be able to manage it via the means of remote desktop, for which a client comes pre-installed with the most recent Microsoft Windows versions; this means that if you have the Microsoft Windows operating system installed on your desktop computer, you will be able to interact with your Windows dedicated server via the means of remote desktop, meaning that you can easily manage your dedicated server using the Windows GUI.

Priority Support

As dedicated server customers are the highest paying for most web hosts, you will find that you receive priority support for your dedicated server, just as long as your web host provides a certain level of support for dedicated server customers, since some don’t provide any support at all for dedicated server customers since they take it for granted that they have the necessary knowledge to be able to administrate their dedicated hosting server effectively; this means that if you choose a web host that provides support for dedicated server customers, you will be able to get support for almost anything quicker than you would be able to with other types of web hosting.

If you are already on a lower end web hosting package, such as a shared hosting package or VPS server, then you should notice that your support requests will be replied to quicker than they were on lower end hosting packages; this means that priority support is one reason that many people choose to move over to dedicated server hosting, since most aren’t happy with the level of support that they are receiving on the lower end package that they are currently on.

Most web hosts also give priority support to dedicated server customers since most dedicated hosting customers are using their servers to host important websites, meaning that it is important for the server to always be up and stable so that the hosted websites can always be accessed; if a dedicated server was to crash, then it could cause a considerable loss to the business that has taken it out, meaning that most individuals and businesses alike try to go with a web hosts that provides priority support where possible, since at the end of the day maximum uptime is what is wanted by the dedicated server clients.

If you choose to go with a web host that doesn’t provide any support for dedicated server customers, then you will need to ensure that you have the necessary knowledge to allow you to administrate your dedicated server effectively.

Disadvantages of Dedicated Server Hosting

There aren’t really any disadvantages that you can directly apply to dedicated server hosting, which is one of the reasons why it is so popular with both businesses and individuals alike. The only factor nearest to a disadvantage that you could apply to dedicated server hosting is the cost of it; this is because dedicated servers cost quite a lot, compared to lower range hosting packages such as shared hosting packages an VPS hosting packages; the cost is only high because the server physically exists, and the original cost of the server for your provider was probably hundreds of pounds, and they need to make that money back in the short term, especially if they are providing many dedicated servers, otherwise they won’t be making any profit on each server. The arrangement that your web host has with their data centre can also affect the price of dedicated servers; this is because data centres charge a certain amount of each individual server that is hosted with them, to cover the cost of electricity, bandwidth and the rack space that has been filled - your web host has to deduct this amount from the cost of your dedicated server since they still want to maintain a profit from your server, but at the same time it needs to be located within a data centre so that it is connected to the internet.

Conclusion

In conclusion, if your website receives a large amount of visitors or is mission critical then Dedicated Server hosting is for you, for the main reason of the added stability which isn’t provided with lower range hosting packages such as shared website hosting and VPS hosting; this means that you are able to ensure that your important website is always available for your visitors, when with lower range packages it might not always be. The fact that your website will be more reliable is because you have your own server with its own resources that are not shared with anyone else, thus meaning that there isn’t anyone else or any other server that will be able to affect the performance of yours in any way; as mentioned previously, you have your own CPU unlike VPS hosting which doesn’t, meaning that your programs and services will always be able to process what they need to without the threat of not being able to because there isn’t enough CPU space available.

Although VPS Hosting does provide you with your own guaranteed RAM and bandwidth, the physical CPU isn’t evenly shared between all the VPS that are hosted on the server concerned, meaning that it only takes one greedy VPS to take the whole hosting node down by using up all the available CPU space; in the case of dedicated server hosting, the CPU is all yours meaning that it can’t be used by anyone else or by any other server - you also have the option to choose from dual or quad core CPUs meaning that you have the ability to give your dedicated server extra reliability.

As mentioned previously, the only way that another server is able to affect the performance of your dedicated server is if another server on the same network as yours was to be DDOS’d, meaning that you have that extra level or reliability and security when compared to other types of hosting; a DDOS would slow the entire network down meaning that all servers would be affected and no-one externally would be able to connect to the servers.

With a dedicated server, you are also given root/administrator access, allowing you to install any programs or services that you want, just as long as they are in line with your web hosts acceptable usage policy - you are also able to carry out custom configurations with root/administrator access, since your dedicated server is your own dedicated environment; with a Linux dedicated server you will be given root access via the means of SSH, and with a Windows dedicated server you will be given administrator access via the means of remote desktop - although the use of remote desktop requires that you have the Windows operating system in order to use the remote desktop client.

Using PHPMyAdmin MySQL Database Manager

PHPMyAdmin is the third party web based MySQL database management panel that is provided and installed as standard with both the cPanel and Plesk control panels, and in the case with Plesk it is provided with both versions (Linux and Windows); if you run your own server without a control panel, then it is also available for download and manual installation since it is open source software meaning that anyone is able to download it for use as many times and on as many machines as they want. With the use of PHPMyAdmin, you are able to manage any databases that you have created from either your cPanel or Plesk web hosting account on the fly, since it is an application that is accessible from your control panel’s homepage and can be used through your web browser, which means that you are able to manage your databases from any internet connected location where you are able to use a computer that has a web browser installed on it.

The main features of PHPMyAdmin allow you to create new tables in your database, as well as to edit and delete others which you have created previously in your database; you can also view and modify the data that has been entered into each individual table, which means that you can easily delete a row for example if you think it might be a fraudulent sign up, in the case that you are running an online shop or some sort of membership system for your website or online community. If you have decided to go with your own install of PHPMyAdmin on your control panel-less server, then you are also given the ability to create new databases on the fly through the system if you are logged into it as the server administrator, or if you are running it on a Linux machine - ‘root’; this makes PHPMyAdmin an all in one solution for someone who wants to be able to manage their stand-alone MySQL databases server on the fly without having to use a desktop database management system.

With the use of PHPMyAdmin in conjunction with a hosting control panel, such as cPanel or Plesk, you are able to manage all the MySQL databases that you have created without the need to open a new window or new program session each time you want to administer a different database; this means that if you are wanting to mange multiple databases that you have created for different purposes throughout your website, you are able to do so without having to use a complicated desktop database management system that might not even let you administer multiple databases, forcing you to open a new session to the server that you are wanting to use each time you want to manage a different databases, even if all the databases that you want to manage are hosted on the same server.

If you are using a control panel in conjunction with PHPMyAdmin, then you will not be able to use it to create new databases for your hosting account, since it is a limit that most web hosts choose to put on the web based administration program since it easily allows customers to create more databases than they are allowed to limited by the amount that has been assigned to their web hosting account; in this case you will have to use your web hosting control panel to add, edit and delete MySQL databases for your web hosting account.

In most cases, you will be using PHPMyAdmin to manage MySQL databases that you have created to be used in conjunction with your PHP based website or application that you are hosting within your web hosting account, which in most cases should be either Plesk or cPanel based to give you the most functionality; this is because PHP and MySQL are known to be the best combination when it comes to databases and scripting languages, since both are open source and can run on either the Linux operating system or on Windows based systems, meaning that PHP and MySQL based websites and applications can be hosted in almost any environment - other combinations are only able to run in certain environments, for example MSSQL and ASP.NET based applications will only run on Windows based servers.

As previously mentioned, MySQL is a database technology that is commonly used in conjunction with the PHP server side scripting language to give developers maximum flexibility when it comes to building their websites and what functionality they are able to achieve with the use of MySQL as the database engine to drive the backends of their websites and projects.

Launching PHPMyAdmin From cPanel

PHPMyAdmin comes installed as default with any cPanel installation, meaning that once you have cPanel installed and configured correctly, you can quickly and easily setup a web hosting account and start adding the databases that you want or need; once you have done that, you can then start using PHPMyAdmin to administer your MySQL databases. Launching PHPMyAdmin from cPanel is a relatively easy task, and is one that can be carried out from any internet connected location, just so long that you can access cPanel from the web browser that you are using; in order to launch PHPMyAdmin from cPanel, you will need to select the icon labeled ‘PHPMyAdmin’ from the ‘databases’ section of cPanel:

One thing to note is that through PHPMyAdmin in cPanel, you are able to administer all the MySQL databases that you have created under your web hosting account, meaning that you don’t have to launch a new window of PHPMyAdmin each time you want to administer a different MySQL database that you have under your web hosting account. Once you have selected the appropriate icon, you should be directed to a page notifying you that PHPMyAdmin is loading, then after that to the PHPMyAdmin homepage:

Launching PHPMyAdmin From Plesk

PHPMyAdmin is also available with both the Linux and Windows versions of the Plesk control panel to allow you to manage any MySQL databases that you have created or want to create within your Plesk based website hosting account; this means that you are able to host your PHP based website or application in a Windows or Linux based environment just so long as the Plesk control panel is installed and that the web server has been appropriately configured to allow this. In order to launch PHPMyAdmin for a MySQL database that you have created through Plesk, you will first need to select the ‘databases’ icon from the hosting control panel for the domain that you want to manage the database for:

You will then be presented with a list of databases that you have previously created in your Plesk website hosting account, the following features are displayed along with the databases name:

• database type (circled red) - this is shown as an image: if the database is a MySQL database then a dolphin will appear in the column concerned, and if it is a Microsoft SQL database then the Microsoft Windows logo will be displayed within this column
• name (circled green) - this is the name of the actual database which you chosen when you were creating it, this is the name that you will need to use in your server side scripts if you are wanting to use them in conjunction with a database that you have created
• server (circled blue) - this is the server that the database is hosted on, in most cases this is the local server on which your website is hosted, although the name of the external database hosting server will be displayed if different
• web admin (circled purple) - if you click on the image in this column, it will load the necessary web administration panel for the database that you have selected it for.

In order to launch PHPMyAdmin for a MySQL database that you have hosted within your website hosting account, you will need to select the web administration icon for a MySQL database that you have hosted within your web hosting account; PHPMyAdmin should then load for the database that you have selected to administrate. One thing to note is that unlike the cPanel version of PHPMyAdmin, the Plesk version will only administer one database at a time meaning that you will have to go back to the Plesk control panel and launch a new session of PHPMyAdmin for each individual database that you want to administer.

The PHPMyAdmin Homepage

Once you have launched PHPMyAdmin from either Plesk or cPanel, you should be taken to the homepage where you can then start to administer the database or databases concerned, with ease. PHPMyAdmin is able to provide you with many different details about the server on which you are hosted, and specifically the MySQL installation that is hosted on the same server as your website, these details might be needed when you are developing your PHP based website or application; the main details that the PHPMyAdmin homepage is able to provide you with include:

• MySQL server version (circled red) - this piece of information is important when developing PHP based websites and applications, since newer versions of PHP might not be compatible with older versions of MySQL and newer versions of MySQL might notbe compatible with older versions of PHP, which is normally the case in most situations
• server and username (circled green) - these two pieces of information are important since you will need them when developing server side PHP based scripts and applications which are going to be utilizing the MySQL database that you are administrating - the server name is the server on which the database is hosted, and the username is what you will need to gain access to the database concerned along with the password that you have specified for the username
• MySQL character set (circled blue) - this piece of information might be important to you when you are developing language related applications, which might be using a range of different languages and characters.

If you have decided to go with a stand-alone MySQL server with a manual PHPMyAdmin installation, then you will also be given the ability to create new MySQL databases through the PHPMyAdmin control panel, although this isn’t possible if you are using a cPanel or Plesk installation meaning that you will have to use your hosting control panel if you want to create new databases for use with your dynamic websites or applications. Links are also provided on the homepage to take you to different parts of the control panel to allow you to manage and administer different features of your MySQL databases, these will be discussed further on.

Administrating a Database

To administrate a MySQL database that you have hosted within your web hosting account, you will need to select one that you have created from within PHPMyAdmin. You will see that all the MySQL databases you have created under your hosting account are listed down on the left hand side of PHPMyAdmin if you are using the cPanel version, and if you are using the Plesk version you should notice that the MySQL database that you have chosen to administrate is listed down on the left hand panel as well:

Once you have clicked on the name of the database that you want to administrate, you should be redirected to the following management page for the database that you want to administrate:

From the management page for the database that you have chosen to create, you are able to carry out the following actions to help administrate your MySQL database effectively:

• create new tables - you will probably find that you will need to create new tables for your database every so often if you are looking to expand the functionality of your PHP based website or application, and new tables will be needed to hold the data so that the new parts of your website or application are able to function dynamically like the rest of the website or application
• management of existing tables - if you already have tables created in the MySQL database that you are managing, then you are able to edit and delete them from the same screen where you can create them from - this means that you can manage your tables easily and effectively through your web browser with the help of PHPMyAdmin.

The above options are available under the ’structure’ tab of the database management panel, other available options include:

• SQL (circled red) - you can use this part of the database management panel to execute SQL queries on your database, for example to create a mass of a new tables without doing it manually, or to do a lookup on your database so that you can search and pull up a specific record that you might have stored within your MySQL database
• search (circled green) - you can use this feature of the database management panel to search through all the records which you have stored in your database, and pull up a specific one for modification or deletion if needed
• query (circled blue) - this feature works in the same way as the SQL feature does, although it is much more manual an better for beginners since it allows you to specify the actual search parameters yourself, meaning that PHPMyAdmin will automatically create the necessary SQL query - basically it works in the same way but without the need for you to enter your own complete SQL query
• export (circled purple) - the export feature of PHPMyAdmin creates a ‘dump’ of your database which is basically an SQL file which you can download and use as a backup of your database, meaning that if your database does happen to get deleted for any reason then all you have to do is run the SQL query contained within the dump file which will then automatically recreate your original database for you
• import (circled yellow) - the import feature of PHPMyAdmin is the opposite to the export feature, meaning that it allows you to import any dumps that you have taken of your database.

Creating a New Table

As mentioned previously, you may want to be creating new tables for your database from time to time so that you are able expand the functionality of your PHP based website or application that is interacting with the MySQL database that you are currently managing through PHPMyAdmin. With expanded functionality, you might be able to bring in more visitors to your website if you are expanding it by increasing the number of services that you are able to provide your customers with, for example. In order to create a new table, you will first need to select the structures tab from the database management panel of the database that you are managing:

Once on the structure page, you will then need to scroll down to the section labeled ‘create a new table on database x’, and will need to enter the following details to aid in the creation of your new table:

• name (circled red) - this is the name that you want to give your table, you should make the name relevant to what the table is going to be used for - i.e. you should call it ‘members’ if it is going to be holding information related to the members of your website
• number of fields (circled green) - this is the number of different rows of data that you want your new table to have, a field is individual meaning that one field is dedicated to one piece of information i.e. a telephone number.

You will then be redirected to the management screen for the table that you have just created, where you will be able to create and manage the fields that you want your new table to contain and in order to help manage and organize the data that you want to store in your new MySQL database efficiently. You should create new tables for each different section of your website to help keep the stored data as segregated as possible to ensure maximum ease when administrating your MySQL database in the future. You should also use as many fields as possible to help keep the stored data segregated, just as you would with tables; if you keep your data organized then will be easier to view and find through the PHPMyAdmin MySQL database management system, and it will be much easier for your scripts and web pages to find the data that you want.

Creating a Field

Fields are the individual table rows in which MySQL stores your data, whether it be the data that you have entered into it through PHPMyAdmin or the data that has been added when visitors sign up to your website. Fields are needed to ensure that your database can be used properly, to store data; without fields in tables, data can’t be stored in your database since there isn’t any way that the data can be categorized and stored in the correct place as would be possible with the use of fields. In order to create a new field under the table that you have previously created, you will need to select a table from the ’structure’ tab of the management panel for the database that you are administrating; you will then be prompted to enter the following data in order to create a new field for the table concerned:

• field (circled red) - this is the name that you want to give your new field, you should make the name relevant to the data that is going to be stored within it - you need to give a field a name since it needs to be identifiable so that it can be used in conjunction with your PHP based websites and applications
• type (circled green) - this is the type of data that you are going to be storing in your new field - the two main types of data are varchar and int, a varchar being just regular words including numbers and int being short for ‘integer’ which in other words is a number which means that this would be the type if you are storing phone numbers under your new field
• length/values (circled blue) - this is what you want to limit the length of the data in the field to - if you are going to be using your database in conjunction with a PHP based website or application then you needn’t worry about this option since you can use your own code in your scripts to limit the length of certain fields
• null (circled purple) - if you choose to make the field null, then you are allowing for the field to be empty when used, meaning that you could end up having many blank fields - if you choose to make it not null then there will have to be data in the field for it to be entered into the MySQL database properly
• extra/auto-increment (circled orange) - if you want to make this the primary field which will be the id field for each separate database record, then you might want to turn on auto increment to ensure that each individual record receives an individual id when it is created or entered into the MySQL database that you are managing
• primary key (circled pink) - if you choose to make the field that you are creating the primary key field, then it will be the one which holds the individual key to identify each different record if needed, it is recommended that you make this field auto-increment as well to ensure that each record receives an individual id.

Once you click ‘create’, you should then be redirected to a page hopefully telling you that your new field has been successfully created and that you can start adding data using it. In most cases you are able to create as many different fields in your database tables as you want, although it is recommended that you only create the ones which you need, since too many can start to affect the performance of your database as well as MySQL in general. One thing to note is that every table needs a primary key field which should auto increment to ensure that each individual record which is created within the table receives a unique id so that they can easily distinguished between and sorted easily.

With the use of MySQL databases, you can easily expand the possibilities and functionality of your PHP based website or application since you are able to make use of the dynamics of having a database and using server side components to make the most out of your web hosting account. For example, you could start a membership system for your website to allow visitors to sign up and view premium content, and in this case a MySQL database would come in handy since you would need somewhere to centrally store the details of all the people who have signed up to your website.

Creating a Dump/Backup

You should regularly backup the contents of your database to ensure that if it does happen to get deleted or corrupted for some reason or another, you can easily restore it without experiencing too much unneeded downtime allowing you to get your website up and running again quicker than others who don’t have any sort of database backup might be able to. In most cases, the database is the centre or heart of your website and without it your website wouldn’t be able to run since all the website’s content is stored within it, and if your website has no content or is broken then you ight find your visitors going elsewhere - it is because of this that you should always take regular backups of your database to ensure that you don’t loose any website critical data or information that can’t get deleted. In order to create your dump/backup, you will first need to navigate to the ‘export’ tab of the database that you want to backup:

You will then be asked to select which tables you want to backup in the case that you are backing up an entire database, by default all the tables that your database contains are selected. You are given a number of different formats that your dump or backup can be downloaded as, some of these different formats being:

• CSV - comma separated values - this is a common file format that is usable on almost any operating system because of its age, dating back to the early days of business computing - is normally used with tabular data, such as that which you are trying to backup from your MySQL database
• CSV for MS Excel 2000 - comma separated values for Microsoft Excel 2000 - see above, the only difference being that this one is designed for use with Excel 2000
• Microsoft Word 2000
• PDF - portable document format - created by Adobe to allow easy exchange of documents, in most cases it is a read-only format meaning that you will be unable to modify the data contained within the backup
• SQL - structured query language - this will create an SQL file which will contain the code which you can easily run as an SQL query on another database or on a new one if the database that you happen to be administrating gets deleted or lost for some reason or another - will restore all original data in seconds, although the timescale does depend on the amount of data being backed up or restored
• XML - extensible markup language - this is normally used by developers since it allows them to specify and create their own tags when they are coding websites or applications - with a backup it utilizes custom tags to arrange the data efficiently within the file that you will be able to download.

Conclusion

In conclusion, PHPMyAdmin is a powerful third party web based database administration tool that will allow you to effectively manage all of your MySQL databases with ease from any internet connected location in the world, thus allowing you to manage your MySQL databases whilst you are on the move. With its management features you are given the ability to create and manage both tables and fields within your MySQL databases so that you can effectively manage and organize the data which you want them to hold; this means that can easily access the information held by your database from your PHP based websites and applications, giving your website maximum flexibility when it comes to expanding the functionality of it. You are given many different expansion options for your PHP based website or application when it comes to MySQL since you can easily create different features that utilize a database to hold your data in either the short term or the long term.

PHPMyAdmin is also an industry leader when it comes to open source database management systems, since it is bundled with both the cPanel and Plesk web hosting control panels, meaning that you are given a large amount of freedom to configure your MySQL databases the way you want them to be when it comes down to being hosting on a shared hosting package utilizes either Plesk or cPanel to manage your website as well as the other on the server as well as the server itself on which you are hosted. If you choose to use PHPMyAdmin on a stand-alone MySQL server then you are given even more advanced functionalities, such as the ability to use it to create new databases if you are logged into it as the root or administrator user thus meaning that you don’t need a third party control panel if you just want to administrate the databases that you are hosting on your server.

PHPMyAdmin is the right solution for you if you are looking to administrate your databases whether you are on the fly, at home or in your office; it contains features that make it superior to may desktop database management systems which gives one advantage, but the best advantage has to be the fact that it is web based meaning that you can access it from any internet connected location, and use any of its features - meaning that for example you could be sitting on a beach in Hawaii with a wifi laptop and be creating new tables for your database so that at the same time you are able to expand the functionality of your PHP website or application - although thats the last thing almost anyone would be doing! PHPMyAdmin is an open source application, meaning that it is freely available for download and use by anyone and can be used as many times as one wants to, meaning that you aren’t restricted by any license terms as you would be with a commercial application of the same type.

As mentioned previously, PHP and MySQL make the best programming and database combination since they are both open source and come with a range of tools and add-ons that allow you to make the most out of both. If you are looking to learn a dynamic server side language which you can use in conjunction with a database system, then you should look no further than PHP and MySQL - there are also a wide range of tutorials available in this blog and on the internet that you can use to aid you in the learning process. You can also buy a wide range of commercial books based around teaching you PHP and MySQL.

Getting Started With cPanel Control Panel

cPanel is the control panel of choice for many web hosts to allow them to provide their customers with Linux based website hosting solutions, and with the launch of the Windows version, Windows based website hosting solutions. cPanel is well known for its loading speeds, since it is very fast when compared to other control panels that are in the same market as it is; the key to its loading speeds is down to it system architecture - for example unlike other control panels, cPanel doesn’t rely on any databases meaning that it has no database application to slow down it down. cPanel provides many features that can be confusing for people who are new to the concept of web hosting, and who have never used a control panel before to manage any aspect of a website or website hosting package; the main aim which most people have is to get their website online and to get the email services for their website configured to that they can start using their new domain and website hosting package - this might be confusing for some at first since there are several different purposes involved with setting up both features, although on further inspection it can be easy for someone with little technical knowledge to achieve their main aim.

If you are an advanced user with a respectable amount of technical knowledge, then you might want to consider customizing your shared hosting environment as to ensure that your custom applications can run without the need for a more expensive hosting solution such as a VPS Server or a Dedicated Server, both of which carry price tags that can be substantially different than those for basic shared website hosting packages. cPanel provides tools and features that you can utilize to manage your hosting account effectively, since it gives you the ability to manage the contents of your web space online which means that you can easily upload and download files that you host from any internet connected location that allows you to connect to cPanel via the cPanel port.

You are also given the ability to view the amount of visitors that your website has received in any period of time; this can be done via the use of a third party program known as ‘AWStats’ which most web hosts provide as standard with their shared cpanel website hosting accounts, this means that if you want to see if an advertising campaign that you have put into practice is working or not since if it was you should be able to notice an increase the amount of visitors to your website.

Other management tools include ‘PHPMyAdmin’ which you can use to manage the MySQL databases that you have created in your cPanel hosting account; PHPMyAdmin is a web interface that is accessible through cPanel which means that you are able to administer your MySQL databases from any internet connected location without the need for any type of desktop database management program. As standard with most control panels, webmail applications are included to allow you to view and manage your emails from any internet connected location; however, unlike other control panels, cPanel give you a choice since both the Horde and SquirrelMail webmail applications are included to allow you to remotely check your email. Other advanced features of cPanel allow you to create and manage custom email filter rules, meaning that you can easily keep out spam that is being specifically targeted at you and your website; this type of configuration is not normally achievable with other control panels, and cPanel also allows you to create custom SpamAssassin rules to ensure that you receive as little spam as possible.

If you are new to using cPanel, then with the use of this article you will be able to upload your new website and configure it so that visitors can start coming, and will also be able to create and configure email accounts for yourself and your colleagues so that you can start communicating electronically; if you have a dynamic website that is based on PHP, then you will also be able to create a MySQL database from scratch - screenshots have been provided to make the learning process even easier.

The Main cPanel Homepage

When you first login to cPanel, you will reach the main homepage for the control panel that will provide you with all the information that you might need to know about the server for your dynamic applications, as well as with all the different options and categories that you might need to make the most of your new website, domain and hosting package. In most cases, you will be using the new cPanel 11, where the main homepage looks like this:

The main cPanel categories that all the different options have been grouped into to ensure maximum ease are:

• preferences - options in this category are mainly to do with the administration of your actual hosting account, such as the password for it and the main contact email address that you want to use with it
• mail - options in this category are related to the email services for your domain name and website
• files - options grouped under this category are related to the management of files that you have hosted within your web space, as well as the management of FTP accounts
• logs - this group of options is related to visitor statistics for your website
• security - options under this category are related to the security of your website, and allow you to password protect any directories that you have as well as the management of any SSL certificates that you might have
• domains - options under this category are related to the management of domain features for your domain
• databases - these options are related to the creation and management of databases under your hosting account
• software/services - items under this category are related to the advanced customization of your hosting environment
• advanced - these features are related to advanced aspects of your hosting environment, and should only be touched if you know what you are doing.

The cPanel homepage allows you to access all the different features that you have been provided with to manage your new hosting account, meaning that you are able to carry out the actions that you need to without any intervention from your hosting company, although you are normally able to turn to them if you require some sort of support for any cPanel feature. Like most control panels, the homepage is able to provide you with detailed technical information regarding your account such as the amount of disk space you are using out of the total amount that has been assigned to you, as well as the amount of bandwidth that has been used up by your visitors in relation to the amount that has been assigned to your hosting package; you are also able to see how many email accounts you have created out of the number you are allowed to create for your new domain.

Creating a Subdomain

You might want to create new domains under your existing domains to split your website up into more manageable areas; these subs are known as ’subdomains’. They can be easily created through cPanel, and allow you to easily upload content to their folders so that you can start serving content from them as soon as the necessary content has been uploading into your web space. In order to create and manage subdomains through cPanel, you will need to choose the subdomains icon from under the domains category:

You will then be taken to the following screen:

To create a subdomain, you will need to enter the following information into the required text boxes:

• subdomain (circled red) - this is where you enter the actual identity of the subdomain that you want to create
• domain (drop down box - circled green) - you will be required to select the domain that you want the sub to be created under, in the case that you are hosting multiple domains under your cPanel hosting account
• document root (circled blue) - this is where any files that you want to be accessible under the new subdomain will be held, it can be anything you want just as long as it is under your account’s ‘home’ directory - cPanel will automatically make this ‘/public_html/chosensubdomain’ when you place your cursor in the text field.

Once you have clicked ‘Create Subdomain’, you will be redirected to a screen which should hopefully confirm that you have successfully created a new subdomain:

Once you have created your new subdomain, you can then move on to uploading your content into the folder that you have pointed the new subdomain towards so that visitors can start accessing it. In most cases subdomains are used to give products their own unique identity in terms of domains, and search engines will normally favour a website that has used subdomains over one which has uses ordinary directories to order their content; this is because it is easier for a search engine to crawl a subdomain website rather than once which uses directories since in most cases the content is much easier for them to find and use, meaning that it would probably be easy for a human to find and use a website which is utilizing subdomains when compared to one which is using directories.

Creating an Email Account

If you want to start communicating with others electronically using emails, then you will need to create email accounts under your hosting account that you and your colleagues can use to communicate with each other as well as with clients and others. cPanel provides you with many different features in order to help you manage your email accounts and to stop any spam from reaching your account, however the management of these features is very complicated and is for advanced users only really; on the other hand, creating an email account is a very simple task which can be achieved by almost anyone. In order to create an email account, you will need to select the ‘email accounts’ option from the mail category:

You will then be taken to the management panel where you will be able to create and manage any email accounts that you want under your hosting account. In order to create an email account, you will need to provide the following information:

• email (circled red) - this is the identity that you want to give the email address - for example the identity in ‘email@domain.com’ would be ‘email
• domain (circled green) - you will need to choose the domain for which you want the email account to be created for in the case that you are hosting more than one domain in your cPanel web hosting account
• password (circled blue) - you will need to choose a password that you will have to use to gain access to the email account, if you are unable to think of one then cPanel will automatically generate one for you
• quota (circled purple) - if you want to limit the amount of space that is used by an email account, then you should enter the amount which you want to limit the account to - just ensure that you have enough space left in your hosting account.

Once you click ‘create’, you will then be taken to a screen that should hopefully confirm that the email account which you want has been successfully created. You will also notice that on the email management panel that there is a table that contains the email accounts which you have already created; this means that you can easily manage the email account which you have just created, as well as others which you might have already created.

Emails are being increasingly used in todays internet connected society to allow people to communicate with each other almost instantly, this means that you can allow you and your colleagues to communicate with each other and clients electronically almost instantly. cPanel also provides webmail applications to allow you to access your email accounts from any internet connected location, enabling you to check your email from almost anywhere in the world; an automatic Outlook configuration file generator is also provided to allow you to configure your Outlook installation to work with your email account if you don’t have the necessary knowledge or information to do it yourself.

Creating a MySQL Database and MySQL User

If you run a PHP based dynamic website which needs to utilize a database, then you will most likely consider using a MySQL database to store the data which your PHP based application will need to access and use to ensure that it is able to run effectively and efficiently. MySQL is an open source database platform, which means it is free and is one reason why you will find it as part of almost any Linux based website hosting package; it is installed as part of cPanel which means that you will find it included with almost any cPanel based website hosting package.

If you create a MySQL database, then you will need to create a MySQL user so that your PHP applications are able to access your MySQL database so that they are able to delete and add new data to the database. In order to create a MySQL database, you will need to choose the ‘MySQL Databases’ option from the databases category. You will then be taken to the following page:

The only piece of information that you will be required to enter is the name of the database that you want to create. Once you click ‘create’, you will be taken to a page which should confirm that the database has been successfully created. However, once you have created a database, you will want to create a MySQL user to allow your PHP and dynamic web applications to access the database.

In order to create a MySQL database user, you will need to return to the MySQL databases homepage. You will then need to scroll down to the MySQL users section:

You will then be required to enter the following information in order to create the user account:

• username (circled red) - this is the login that will be used in order for your scripts to access the database
• password (circled green) - you should apply a password to the user account, otherwise hackers might be able to find a way into your database.

Once you click ‘create’, you should then be redirected to a page which should hopefully confirm that the user account has been successfully created. In order for the user account to be functional with the MySQL database that you have just created, you will need to scroll down to the section labeled ‘Add User to Database’:

You will need to select the user account that you want to assign, then the database to which you want to assign the user account. Once you have done that, you should then be redirected to a page confirming that the user has been successfully assigned to the database.

With the use of MySQL databases, you should be able to make your website more dynamic in the way that it functions since you will be able to store the content and data that it requires in one central location; this means that users will be able to have a more interactive experience with your website - this means that you are able to provide your website’s visitors with a range of new services based around a database. cPanel allows you to manage any MySQL databases that you create with ease; you can use the web based third party PHPMyAdmin application in order for you to manage your databases via an online interface from any internet connected location, meaning that you are able to manage your cPanel MySQL databases from almost anywhere in the world.

Uploading Your Website

One of the main things that you will be wanting to achieve with your new cpanel website hosting package is the ability to host your website under the domain that you have purchased for your new hosting account. With a website you will be able to show off your business to prospective clients, or provide existing clients with a place where they can manage the account that they have with you; this means that you could easily gain your business an extra source of income with the use of a website to sell your products online.

When uploading your website to your web space, you have the choice to make of how to upload it - you can use the classic method of FTP which means that you connect to your web space via FTP using an FTP account that you have created through cPanel, or you can use the cPanel file manager to upload all your files into your web space although it could take considerably longer.

If you want to upload your website via FTP, you will first need to go to the FTP account manager by select the ‘FTP accounts’ option located under the files category on the cPanel homepage:

To create an FTP account, you should look at the first section of the page which is titled ‘add FTP account’; in this section, you will need to enter the following information:

• login (circled red) - this is the name of the actual FTP account and is what you will use to login into your web space via FTP
• password (circled green) - it is highly recommended that you password your new FTP account for maximum security
• home directory (circled blue) - this is the highest level directory to which you want the account to have access.

You should then be directed to a page which should hopefully confirm that the FTP account has been successfully created. You can then proceed to use your favourite FTP client to upload your website’s files to your web space using the FTP account that you have just created.

If you want to upload your website’s files using the cPanel file manager, then you will need to select the option labeled ‘file manager’ from the file category of the cPanel homepage:

The following box will pop up, and you will need to select ‘web root’ (circled red):

You will then need to navigate to the folder where you want to upload your website’s files to if necessary. You will then need to select the ‘upload’ option from the toolbar of the file manager:

You will then be taken to the following page:

As you can see, you are given three boxes in which you are able to upload files. You are given the option to add additional boxes if needed.

In theory, it is much easier for you as a beginner to upload your files to your cPanel web space via the means of FTP, since you can get more files placed into your web space in one go than is possible with the web based file manager. However, in terms of ease it can be sometimes easier to use the web based file manager since you are able to upload files using it from any internet connected location so long as you have a reasonable connection speed and are able to access your cPanel account. So in practice, if you want to upload your files conveniently and efficiently then you should use FTP to upload your files, but if you don’t have much time on your hands and are in a public place such as an internet cafe that might block the FTP port then you should use the web based file manager.