Using Database Features in cPanel

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.

Managing MySQL databases and users

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.

Managing PostgreSQL databases and users

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.

Accessing phpMyAdmin and phpPgAdmin

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.

Configuring remote MySQL access

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.

Using phpMyAdmin to copy a MySQL database

You can use phpMyAdmin to quickly and easily copy a MySQL database, and this article shows you how.

Changing the MySQL collation settings in phpMyAdmin

Learn how to change the collation settings for MySQL databases and tables using phpMyAdmin.

Optimizing and repairing MySQL databases with phpMyAdmin

This article covers how to use phpMyAdmin to optimize and repair MySQL databases, with step-by-step instructions provided.

MySQL passwords do not work after upgrade

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.

Deleting MySQL database tables with phpMyAdmin

This article covers how to use phpMyAdmin to delete (drop) tables in a MySQL database, with step-by-step instructions provided.

Remote access for MySQL TCP/IP connections on cPanel

This article discusses MySQL TCP/IP connections on shared hosting accounts. You must whitelist client IP addresses in the Remote MySQL tool in cPanel, including the local loopback address (127.0.0.1).