BuycPanel Blog

BuycPanel Blog

Latest news and updates

9/05/2014 – Creating and Managing PostgreSQL Databases Using cPanel

Posted by Jamison on 05 09 2014.

cPanel is deemed to be the most popular choice of panel among hosting providers. It is preferred by most business developers and website owners because it makes website administration easy and fast. You know you are working with a graphical web-based web-hosting control panel that gives you a list of features that you will surely enjoy.

 

The important thing about cPanel is that you should know how to work on the basic and advanced features so you can work around on the tools and apps that you need. Basic apps include changing your cPanel style, managing your email accounts, setting up your webmail, creating a spam assassin, setting up your email forwarders, your email auto responders.

 

Advanced options and tools include creating an MX Entry maintenance, securing your site’s backup, view your files using the cPanel disk usage viewer, access your site’s files through FTP, protect your directories using a password, utilize your IP Deny Manager, use your HotLink protection and leech protection, and creating cron jobs.

 

One of the significant and advanced tools of cPanel is managing your databases. Once you are already familiar with this option, you can create MySQL and PostgreSQL databases and users. This allows you to get access and modify your databases.

 

PostgreSQL is an object-relational database management system. As compared to MySQL, it is not very popular. But this also remains a choice among other website developers as an option for their websites. cPanel gives you the option of managing your PostgreSQL databases.

 

Here is the step by step process on how you can manage your PostgreSQL databases:

 

  • Login to cPanel
  • Select PostgreSQL Databases option located under Databases navigation panel
  • Provide a name for your database and select Create Database button. The database that you just created will appear under Current Databases panel. However, you will not be able to use it since you haven’t created a user and added the required privileges.
  • Scroll down and locate the section named – PostgreSQL Users
  • Provide a username followed by password (twice). You can also make use of the Password Generator to automatically populate the password. Select Create User button to create the user.
  • Finally, you should add the created user to the database by selecting the required values from Add User to Database section. This option will appear after you create username.

 

These are also the tools that you can use in the databases section:

 

  • MySQL Databases
  • MySQL Database Wizard
  • phpMyAdmin
  • Remote MySQL
  • PostgreSQL Databases
  • PostgreSQL Database Wizard
  • phpPgAdmin

 

The key to ensuring the success of your website is that you should know how the apps and tools work—their function, their purpose, and how they can impact your website. It may sound too techie savvy—terms such as SQL (Standard Query Language) but you realize that you need them to maintain your databases. This is the international standard in retrieving and querying information from your database and it is important that you understand them.

 

Basically, cPanel provides a tool which is the MySQ. This is an SQL server as it works by responding to requests for information that are written in SQL. Once you are already familiar with the available programming languages on how you can communicate with MySQL, you can already choose from this section.

 

cPanel allows you to create an effective website that will bring significant ROI to your company, but it also allows you to manage your website without the hassle and scare of technology.