UK Web Hosting Blog | cPanel Hosting | Windows VPS | Dedicated Servers Dedicated Server Hosting, Windows VPS, web hosting articles, Linux Hosting, Game Servers, VPS Hosting, Cpanel Web Hosting, Reseller Hosting, Shared Servers, Cheap Website Hosting, Web hosting UK, Managed Hosting

This article will explain you on “How to manage MySQL or PostgreSQL database in cPanel”. After logging into cPanel you will find the MySQL or PostgreSQL icons. CPanel screen lets you to create or work with those types of databases. CPanel uses a similar interface for both types of databases, that’s why most of the web host offers MySQL.

On the MySQL/PostgreSQL cpanel screen you will see four main sections as shown in the figure below. The very first section lets you to create and work with the database. Below that there is another section which allows you to create database users that will be able to access the databases. Next section is to setup remote access to your databases only if your web host allows. At last there is a hyperlink given to phpMyAdmin or phpPgAdmin, the web interfaces for advanced work with your databases.

How to create a database?

Its not so hard to create database, but there are few things you will need to know. The first thing you are gonna need to create database is the last item in database section. Just write the name of the database into the Db: field and simply click on Add Db button. The database of the name will be created. There will be slightly difference in actual database name you have chosen. It will be created with your cPanel username and with an underscore added before the name you chosen. For example: domain_database1.

How to create a database user?

To use a created database you need atleast one user into the database. For creating a new user simply type a username and password in the “users:” section and click on Add User. A new user will be created immediately. The database username will look like this “domain_robin“.

Now, how to add a user to the database?

Now you have to associate the above created user with the database. Now, if you check out the above Add Db field it has a set of drop-down lists. The first field allows you to select a user that you have created and in second field you have to select the database that you want to associate with that user. Now just click on Add User to Db and its done. Also, you can add a single user to multiple databases if you wish to.

Once you have associated a user with the database you will notice that the listing for that database get more detailed. It will show you the database name followed by some links to delete or repair the database and then you will be able to see all the users in the database. Also, it will show you some sample code that shows you how to connect to the database in PHP, Perl or JDBC script.

How to remove or repair a database?

Just next to the username there is a button called Delete, but this can be confusing as deleting a user from a database will only remove the user and all the records the user had in that database. It will not affect the actual user you created, it will still work in other databases. As well as there is Check button given to check database for problems, and if it has any errors just click on Repair. And still if that doesn’t work then you must contact your web host.

Bookmark Us

Posted under Webhosting

Windows and Linux are the two operating systems mostly used for hosting web servers. While each has its advantages, the so called LAMP (Linux, Apache, MySQL, and PHP) combination is preferred for new installations that don’t have to worry about integration with existing or legacy systems.

Why is Linux hosting always a preferred alternative?

The advantages that Linux hosting offers in combination with other open source software like PHP and MySQL partly accounts for its popularity. Linux itself is open source and Linux hosting offers all the advantages associated with open source software. Open source software allows constant improvements to be made by any person who is interested to do so. This automatically adds a large number of people who work on problems to make the software better.

It is also likely that these programmers work on problems that they have faced and are therefore coming out with relevant solutions. The fixation of problems and bugs is also faster in open source software, being a continuous process.

One of the biggest advantages is that you can post any problem that you face and somebody might come up with a solution. You can even engage your own programmer to do this. Another advantage of open source software is that you are not tied to any particular vendor. All these advantages are automatically passed on to Linux hosting.

Being open source is not the only advantage that Linux and Linux hosting offer. Linux hosting supports more cross platform applications, and offers a higher portability than most proprietary operating systems. Linux runs on a variety of hardware platforms, which means that you have the freedom to select the hardware or even migrate to a different hardware later without any hassles.

Linux hosting is more stable since Linux is an extremely stable operating system. Some of the other popular operating systems slow down after running for a while, necessitating a reboot after comparatively long periods of running, to ensure performance.

Linux can go on for months at a time without any problems such as memory leaks that plague other systems. Apart from this Linux provides a number of system-based safeguards, including better security, safety against attacks, and recovery procedures, these make Linux hosting a robust and secure alternative.

Linux can communicate with most other systems without any problem. Interoperability and communication are two important requirements in today’s computers, both of which are met by Linux. There are a number of third party tools that have been made available under Linux over the years, enabling you to perform many common tasks with ease. Linux hosting can offer these advantages to you in turn.

Linux hosting is cost effective. Theoretically, Linux is available free of cost. However, you pay for many commercial versions that you can use on your computer. Since there is no cost to the commercial provider on account of the effort put in for original development that the seller has to recover, this cost is lower than comparable costs for other operating systems.

Moreover, unlike other operating systems, you generally don’t pay for multiple installations of the same software. This means that even if you pay the same amount for the original copy of the software, you don’t incur additional cost for a number of installations, bringing the real cost further down. The cost advantage does not end there. Because of its stability and the availability of a range of tools, the ongoing cost of operation of Linux Hosting is quite low.

The performance of Linux systems is quite good and you can get good speeds even with some of the older computers under Linux. Linux has the capability to handle a large number of simultaneous users.

This makes Linux hosting an ideal choice for servers, particularly web servers, where the traffic may be large with a large number of users simultaneously accessing the server. The ability of Linux to run without deterioration over long periods of time, handling a large number of customers with a high level of performance becomes a great advantage for web servers.

One of the major advantages of Linux is that it was originally developed over the Internet and hence is automatically suited for working in a networked environment both as a client and as a server. This makes Linux hosting an ideal choice for network-based applications such as the Internet.

If you are wondering what all this has got to do with you, if you are using a shared web hosting service, the answer is simple. In a competitive world, the advantages that the provider of the Linux hosting service enjoys are automatically passed on to you.

Bookmark Us

Posted under Linux Hosting