Knowledge Base

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.

Managing PostgreSQL databases and users

Learn how to manage databases and users for PostgreSQL databases.

Accessing phpMyAdmin and phpPgAdmin

You can use phpMyAdmin and phpPgAdmin to manage all aspects of your databases. You can create and browse tables, import data, and much more.

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.

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 in this article.

Optimizing and repairing MySQL databases with phpMyAdmin

Learn how to use phpMyAdmin to optimize and repair MySQL databases.

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.