phpMyAdmin is a web-based tool that allows you to manage databases directly from your browser. With phpMyAdmin, you can view, edit, import, export and delete data in databases used by websites and web applications.
Overview
phpMyAdmin is included in cPanel and gives you access to all databases associated with your hosting account.
This feature has several advantages. You can:
Manage databases directly from your browser
View and edit tables and data
Import and export databases
Run SQL queries
Troubleshoot databases and web applications
When you finish this guide, you will know how to open phpMyAdmin and access the databases in your hosting account.
Important information
phpMyAdmin is used to manage the content of databases, but should not be used to create new databases or database users.
For the creation and management of databases and database users, we recommend using the Database Wizard or Manage My Databases features in cPanel.
⚠️ Important: Changes made in phpMyAdmin come into effect immediately. Be careful when editing or deleting data, as this may affect the website or application that uses the database.
Prerequisites
Before you start, make sure:
You have access to cPanel
You have at least one database in your hosting account
You have the necessary rights to manage the database
Step 1: Log in to cPanel
If your hosting service supports cPanel, you can log in directly from the landing page in the customer area.
This is how you do it:
Find your hosting service under the list of active products/services
Click on the button "Log in to cPanel"
You are now automatically logged into cPanel without having to enter your username or password again
Step 2: Open phpMyAdmin
When you are logged into cPanel, click on phpMyAdmin.
You are now automatically logged into phpMyAdmin and sent to the database overview.
Step 3: Select the database you want to manage
In the menu on the left side, all databases available in your account are displayed.
Click on the database you want to manage.
When the database is selected, the database's tables appear in the main window.
From here you can, among other things:
Display the contents of tables
Edit existing data
Run SQL queries
Import databases
Export databases
Create or delete tables
💡 Tip: If you are unsure which database your website is using, you can often find the database name in the site configuration file, such as wp-config.php for WordPress.
Step 4: Perform database management
Once you have selected a database, you can use the menus at the top of phpMyAdmin to perform various tasks.
Common features include:
Search – Search for data in the table
Structure – Manage the table structure
SQL – Run SQL queries
Import – Import a database file
Export – Download a backup of the database
⚠️ Important: Always create a backup of the database before making major changes or running SQL queries that change any data.
Summary
You have now learned how to open phpMyAdmin in cPanel and access the databases in your hosting account.
phpMyAdmin makes it easy to manage databases, edit data and perform advanced database tasks directly in your browser.
By making regular backups before making changes, you can reduce the risk of data loss and make your database management safer.