How to Access phpMyAdmin in cPanel
phpMyAdmin is a tool that is used to view and manage databases. It is a graphical tool that helps users to manage databases. Users can use it to avail almost all possible operations related to databases.
Example – Users can use the phpMyAdmin tool to import/export SQL queries or can perform any admin-level operations such as adding databases, exporting, or deleting databases.
Luckily, the phpMyAdmin tool comes pre-installed with many web hosting accounts and can easily be accessed through cPanel
To access the phpMyAdmin from cPanel, simply login to your cPanel account and click on the phpMyAdmin icon under the category Databases.
You will be redirected to the phpMyAdmin page and see the following:
- General Settings
- Appearance Settings
- Database Server Information
- Web Server Information
- phpMyAdmin Links
What you can do within the phpMyAdmin interface.
First, you need to create a database. (Click here to know more on how to create a database.)
Viewing your Databases
To view the databases, just click on the database name on the left pane of the phpMyAdmin homepage or click on the Database Tab on the top of the screen. Once you clicked on the Database, it will show you the structure of the database and then the table names which is the content of your database.
Browsing your Databases
When you have selected the Database, you can browse it by clicking on the “Browse” button under Action (just beside the Table name) while in the “Structure” view. Browse view displays the rows of data from your database. Also, you can navigate to different rows of data or pages by clicking on > or >> buttons on top of the table page.
To view the current MySQL processes that are running, you can click on the “Status” Tab from the phpMyAdmin home screen.