How to use phpMyAdmin from cPanel

How to use phpMyAdmin from cPanel

phpMyAdmin is an open-source software tool written in PHP, designed to manage MySQL and MariaDB databases through an intuitive web interface. If you are a PlatiniumHost client, you will have access to cPanel, and from there, you can access phpMyAdmin to visually manage your databases, without the need for complex commands. This article will guide you step-by-step on how to make the most of this powerful tool to manage your databases, from viewing structures to executing SQL queries and managing backups.

Accessing phpMyAdmin through cPanel

The first step to start using phpMyAdmin is to access your cPanel control panel.

1. Log in to cPanel: Access your cPanel using the credentials provided by PlatiniumHost. Typically, you can do this by visiting yourdomain.com/cpanel or yourdomain.com:2083.
2. Navigate to the 'Databases' section: Once inside cPanel, look for the 'Databases' section. Here you will find several tools related to database management, such as 'MySQL Databases', 'MySQL Database Wizard', and 'phpMyAdmin'.
3. Click on 'phpMyAdmin': Within the 'Databases' section, you will see the 'phpMyAdmin' icon and link. Click on it to open the phpMyAdmin interface in a new browser tab or window.

Once you have accessed it, you will see the main phpMyAdmin interface, showing a summary of your MySQL server and the available databases in the left column. This interface will allow you to interact directly with your databases without the need for a command line.

Getting to know the phpMyAdmin interface

The phpMyAdmin interface is designed to be user-friendly, but knowing its key components will help you navigate and perform your tasks more efficiently:

• Left panel: Here all the databases you have access to are listed. Clicking on a database name will expand it to show all the tables it contains. You can select a table to view its details in the main panel.
• Main panel: This is the largest and most dynamic section of the interface. It displays the details of the selected database or table and is where you will perform most of your operations. It contains several tabs such as 'Structure', 'SQL', 'Search', 'Insert', 'Export', 'Import', 'Operations', etc., each with a specific function.
• Top bar: Contains quick links to the phpMyAdmin homepage, official documentation, and options to change the language or visual theme of the interface.

Common tasks in phpMyAdmin

Viewing the structure of a database and its tables

To understand how your information is organized, it is essential to review the structure of your databases and tables.

1. In the left panel, click on the name of the database you want to explore.
2. In the main panel, the 'Structure' tab will be automatically selected, showing a list of all tables within that database. You will see information such as the table name