Create, Remove and Repair a MySQL or PostgreSQL Database in cPanel

This article explains how the administration of MySQL database or PostgreSQL in cPanel. After logging in cPanel find the MySQL or PostgreSQL icons. CPanel screen, you can create or work with these types of databases. CPanel uses a similar interface for both types of databases, which explains why most web hosts offer MySQL. On the MySQL / PostgreSQL cpanel you can see the screen divided into four zones, as shown in FIG. The first article, you can create and work with the database. Among them, there is another section that you have the user database is able to access the databases will be able to create. Next section is the installation of remote access to your database if your host allows. Finally, there is a link to phpMyAdmin or phpPgAdmin given Web interfaces for advanced work with your databases. CPanel MySQL database PostgreSQL HostingHow a database? It's not so hard to create the database to create, but there are some things you should know. The first thing you'll need to create databases is the last item in the database section. Just type the name of the database in the DB: field and click the Add DB button. The database of names will be created. There is little difference in the name of the current database that you have chosen. It will be your username and cPanel created with an underscore before the name you selected. For example: domain_database1. How to create a user database? To create a database user, you must use atleast in the database. To create a new user, simply enter a username and password in the "users" and click Add User. A new user is created immediately. The username of the database is as follows domain_robin "look". Well, you take a user in the database? Now you need to pair the top user-created database. Well, if you add on top of the page area DB has a number of dropdown lists. The first box to a user that you created and in seconds, you need the database that you want to assign that user to choose. Now, click Add a user to the DB and its done. You can also add a single user to multiple databases, if you want. If you are a user logged into the database, you find that the detailed prospectus for the database. It shows you the database name, followed by a couple of links to remove or repair the database and you will see in a position to all users in the database. In addition, it shows you some sample code that shows you how to connect database in PHP, Perl script, or JDBC connections. Windows XP or repair a database? Right next to the user, there is a button called delete, but this can be confusing, such as deleting a user from a database is only the user to remove and the user has all the records in this database. This is not the actual user is created, still works in other databases. In addition to the control button, there is the database to look for problems, and if there are errors, simply click on Repair. Yet, if this does not work, then you have your Web host connection.

Or for further references, check out the following resources:

• cpanel crystal tutorial databases
  The Databases section allows you to create MySQL and PostgreSQL in cPanel: MySQL Databases. MySQL Databases - Through this tool you can create new MySQL databases, list and remove the
• mysql databases
  MySQL® Databases . Databases offer a method for Click Create Database. Click Go Back. The new drop-down menu, select the database you wish to repair. Click Repair DB. cPanel will
• cpanel tutorial databases
  cPanel Tutorial: Database. The Databases section allows you to create MySQL and PostgreSQL databases and users, to this tool you can create new MySQL databases, list and remove
• working with databases in cpanel archive serchen interactive
  with Databases in cPanel Clicking on the MySQL or PostgreSQL icons on the main cPanel screen will allow you to create or Removing or Repairing a Database Next to click Repair if
• cirtexhosting adds support for postgresql databases in cpanel
  to create and manage PostgreSQL databases through the cPanel both MySQL and PostgreSQL databases when creating and remove tags of your audio files, import from online databases