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.

Posted under Webhosting

CPanel should be the first thing you must consider while searching for the web hosting service provider. It is very much essential as it provides the end user with a more convenient and easier way to manage your website.

Logging into and using the different programs can be done prove to be straight forwardly. Using cPanel you can easily and quickly setup a blog, a bulletin board made using PHP or a content management system.

It works even better when Fantastico scripts are used with it. It sets off a multitude of tasks, like MySQL table creation for different programs, removing the manual importing of scripts created by third-party vendors. Together, cPanel and Fantastico are able to streamline the process for the end user in setting up software and other applications.

CPanel has efficiently combined the scripts and programs that which used to operate separately. CPanel was able to standardize these programs and scripts, which made web hosting and setup a uniform package for users.

However, there is a disadvantage for using cPanel. Since it is widely used, it has become the method of phishers and hackers that create scripts that run and command it to setup unauthorized sub-domains that will be able to gather information from innocent victims. This method is referred to as phishing, and the user must always look out for signs of these when utilizing the cPanel.

Summary about cPanel Hosting – The Most Admired Web Hosting Control Panel

CPanel is where you monitor and manage your website; it is a web based client interface. CPanel lets you control your host account environment. It allows users to monitor things like disk space and bandwidth usage. CPanel also allows you to store your data in MySQL databases. Within the CPanel you will usually also has access to PhpMyAdmin, which offers you a feature to store database backups on a file and download a dump of the database.

Many hosting providers advertise that you can host unlimited sites, create your own packages and control it all within a slightly more expensive reseller package. This is achieved by using a software add-on to cPanel called WHM. This for the master account URL for the reseller account means that WHM can be opened and from within WHM all the sub-accounts can be viewed and maintained.

Fantastico is an excellent web application typically based on cPanel/PHP. The application integrates with cPanel and gives user the ability to install many free application and scripts automatically. These scripts vary widely in their applications from shopping site payment cart systems, to complete web site content management.

We like the cPanel Email Account Creator which is the perfect script to setup a web email system to allow your users to signup and start sending emails with your hosting. The cPanel system helps you to set up databases and forces your databases to include a special prefix so that it may distinguish your database.

The cPanel features provided by the free web space hosting providers that use it, for example, will vary, but usually they still include at least a file manager for uploading and editing your free web pages online.

Some include all the features of paid hosting companies, such as MySQL databases, Fantastico script installer, Cron jobs manager, Add-on domains, Email management tools, AWSTATS and the Webalizer and other website statistics programs, and so on. If they do provide even half of these for free, you have found a great offer.

Spam Assassin is available on many cPanel web hosting sites. Spam Assassin is a mail filtering system which scans each and every email received under the email accounts hosted from your cPanel account for characteristics which are typical of spam messages.

For newbie’s, cPanel is the best control panel with lot of opportunities that are easy to use. CPanel works with most common browsers, such as IE, Opera, Firefox and others.

Posted under Webhosting