BuycPanel Blog

BuycPanel Blog

Latest news and updates

12/20/2013 – Dealing With Your cPanel Database

Posted by Jamison on 20 12 2013.

Databases are large or small organized collections of data necessary to run web-based operations. They can be tricky to manage, especially if you don’t have the right tools to handle them. Lucky for you, cPanel, the world’s most widely used webhosting and management tool, has many features to allow you to manage your databases properly.

 

Let’s have a look some of the features in the latest version of cPanel (11.40) under the Database section:

 

MySQL Databases

 

This feature allows you to manage all aspects of your database, this includes creating and deleting databases, checking and repairing databases, creating database users and defining their privileges (also removing them), searching databases and deleting a MySQL user.

 

All these function can be carried out with just a few clicks of the button.

 

MySQL Database Wizard

 

This feature provides another way set up a MySQL database, along with the requisite accounts and privileges.

 

To set up a database enter a name for the database in the New Database field.    Click on Next Step.

 

Enter a name for the user allowed to manage the database in space for Username. Type a password and confirm it. Click the Create User button.

 

Select the privileges you wish to grant the user, but better you just select ALL PRIVILEGES. Click on Next Step.

 

cPanel will now display a message stating that the database and user account were successfully set up.

 

phpMyAdmin

 

With phpMyAdmin, you can make changes to MySQL databases over the Internet. You can carry our varied functions like adding or deleting databases, creating or deleting tables, setting permissions and executing SQL statements.

 

 

The rest of the features have to do with PostgreSQL. Just what is the difference between MySQL and PostgreSQL anyway?

The main different between them is ANSI SQL compliance; PostgreSQL complies with most ANSI SQL standards while MySQL only adheres to some of them.

 

Both are run by different companies. PostgreSQL relies on a unified database server with a single storage engine while MySQL has two layers, an upper SQL layer, and relies on a set of storage engines.

 

While it was true that MySQL was faster to run than PostgreSQL, the latter program has made significant strides in its subsequent versions. The current versions of the two, MySQL 5.6 and PostgreSQL 9.3, are almost at par when it comes to speed.

 

Only PostgreSQL has foreign key support while only MySQL has different table types when displaying data.

 

Both can support Windows, database replication ODBC and JDBC.

 

 

So, back to the rest of the functions.

 

PostgreSQL Databases

 

This feature functions like the MySQL Databases, but for PostgreSQL files.

 

PostgreSQL Wizard

 

Like its MySQL counterpart, this feature provides another way set up a PostgreSQL database, along with the requisite accounts and privileges.

 

phpPGAdmin

 

With phpPGAdmin, you can make changes to PostgreSQL databases over the Internet in the same way phpMyAdmin does. These functions include, but are not limited to, adding or deleting databases, creating or deleting tables, setting permissions and executing PostgreSQL statements.

 

 

Managing your databases need not be a headache, make sure you have the proper tools to help you out. Buy cPanel now.