Create Remove and Repair a MySQL or PostgreSQL Database in CPanel

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 them. 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?


Continue reading »