Accessing PhpMyAdmin in the cPanel panel

Introduction

In this tutorial, we will present the steps necessary for accessing PhpMyAdmin in the cPanel.

Requirements

Authentication data for the hosting package.

Steps

- Access the cPanel administration panel, authenticate with the administration data (username/password) provided by Hostico, and after successful authentication, go to the Databases section where we will click on PhpMyAdmin.

- The application interface will open in a new page where there will be various options for editing, modifying tables, import/export, etc.

On the left side, the databases in the account will be displayed. By clicking on the name of one of them, its tables will be shown, as well as the options at the top middle, options that can be used on that selected database.

In addition to the databases associated with the hosting account, there may also be a standard database automatically created by the system (information_schema) that belongs to the system, and we ask you not to modify/edit it to maintain the proper functionality of the hosting account.

Depending on what you will be working on in the databases and their tables, we recommend paying close attention to editing them, as any incorrect or incompatible modification will directly and usually instantly affect the website that uses that database.

The most used options in PhpMyAdmin for the database are Export and Import.

The export option will compress the entire database you have selected on the right side of the page into a file with the .sql extension, which you will be able to save locally on your computer.

The import option will be used (after a drop of the current tables has been performed) to import the .sql database file that was previously exported either from the same account or from another hosting, considering that the databases contain the majority of the website's information.