Structured Query Language (SQL) is an international standard used to query and retrieve information from databases. cPanel supports two of the most widely-used database systems, MySQL® and PostgreSQL. These database systems are complete SQL server and database solutions. You can interact with MySQL and PostgreSQL databases using a wide variety of programming languages, including PHP, Perl, and Python. MySQL and PostgreSQL are open source software and generally free for commercial or personal use.
Read these articles for more information about how to manage databases using cPanel.
Learn how to manage databases, users, and user permissions for MySQL databases. This article covers how to create, modify, rename, and delete database users. It also covers how to create databases, add users to databases, repair databases, revoke user privileges, and delete databases.
Learn how to manage databases, users, and user permissions for PostgreSQL databases. This article covers how to create, modify, rename, and delete database users. It also covers how to create databases, add and remove users from databases, and delete databases.
You can use phpMyAdmin and phpPgAdmin to manage your databases through a convenient web interface. This article covers how to access phpMyAdmin and phpPgAdmin through cPanel.
You can use cPanel to configure remote access to your MySQL databases. With remote access enabled, external hosts can access your MySQL databases. This article covers how to add and remove remote host access to your MySQL databases.
You can use phpMyAdmin to quickly and easily copy a MySQL database, and this article shows you how.
Learn how to change the collation settings for MySQL databases and tables using phpMyAdmin.
This article covers how to use phpMyAdmin to optimize and repair MySQL databases, with step-by-step instructions provided.
MySQL user passwords may not work after a server is upgraded to MySQL 5.6.5 or a newer version. This article describes how to resolve the problem.
This article covers how to use phpMyAdmin to delete (drop) tables in a MySQL database, with step-by-step instructions provided.