How to Use phpMyAdmin in cPanel - Knowledgebase

Introduction

phpMyAdmin is a web-based database management tool included with cPanel. It allows you to manage MySQL and MariaDB databases through an easy-to-use graphical interface without needing to use command-line tools.

With phpMyAdmin, you can:

View database contents
Create and modify tables
Run SQL queries
Import databases
Export database backups
Edit records
Repair and optimize tables

This guide provides an overview of the most common phpMyAdmin functions.

Accessing phpMyAdmin

Step 1: Log in to cPanel

Step 2: Open phpMyAdmin

Navigate to the Databases section and click phpMyAdmin.

phpMyAdmin will open in a new page and automatically authenticate you using your cPanel account.

Understanding the phpMyAdmin Interface

The phpMyAdmin interface is divided into several sections:

Navigation Panel

Located on the left side, this panel displays all databases associated with your hosting account.

Expanding a database allows you to view its tables.

Main Workspace

The center area displays database information, tables, records, and query results.

Menu Tabs

Common tabs include:

Browse
Structure
SQL
Search
Insert
Export
Import
Operations

Viewing Database Tables

To view a database:

Click the database name in the left navigation panel.
A list of tables will appear.

Common tables in WordPress databases include:

wp_posts
wp_users
wp_options
wp_comments

Selecting a table displays its records.

Browsing Database Records

To view the contents of a table:

Select the table.
Click the Browse tab.

You can:

View records
Search data
Edit entries
Delete records

Important

Editing records directly affects your website or application. Always create a backup before making changes.

Running SQL Queries

The SQL tab allows you to execute custom SQL commands.

Example Query

To display all records from a table:

SELECT * FROM wp_users;

To run a query:

Select the database.
Click the SQL tab.
Enter your query.
Click Go.

Warning

Incorrect SQL commands can modify or delete data. Ensure you understand the query before executing it.

Importing a Database

phpMyAdmin can import database backups and SQL files.

To Import a Database

Select the destination database.
Click the Import tab.
Click Choose File.
Select the SQL file from your computer.
Click Go.

phpMyAdmin will process the file and import the database contents.

Supported Formats

Common formats include:

.sql
.sql.gz
.zip

Large databases may exceed hosting account upload limits. Contact your hosting provider if you encounter import restrictions.

Exporting a Database

Exporting creates a backup of your database.

To Export a Database

Select the database.
Click the Export tab.
Choose an export method:
- Quick
- Custom
Select SQL as the format.
Click Go.

The database backup will be downloaded to your computer.

Recommended Practice

Create a database backup before:

Updating website software
Installing plugins
Modifying database records
Running custom SQL queries

Editing Database Records

To edit a record:

Open the table containing the record.
Click Browse.
Locate the desired record.
Click Edit.
Make your changes.
Click Go to save.

Changes take effect immediately.

Searching a Database

To search for information:

Select a database or table.
Click the Search tab.
Enter your search criteria.
Click Go.

This is useful for locating specific content, usernames, email addresses, or settings.

Repairing and Optimizing Tables

Database tables can occasionally become corrupted or fragmented.

Repairing Tables

Select the table.
Click the Operations tab.
Choose Repair Table.

Optimizing Tables

Select the table.
Click the Operations tab.
Choose Optimize Table.

These maintenance functions may improve database performance and resolve certain issues.

Common Uses for phpMyAdmin

WordPress Administration

phpMyAdmin is commonly used to:

Reset WordPress settings
Update site URLs
Modify user accounts
Troubleshoot plugin issues
Recover administrative access

Database Backups

Exporting databases provides an additional backup option before making significant changes.

Troubleshooting

Developers often use phpMyAdmin to identify database errors and verify application data.

Security Best Practices

When using phpMyAdmin:

Create a database backup before making changes.
Avoid running unfamiliar SQL commands.
Do not delete tables unless you understand their purpose.
Use strong cPanel passwords.
Log out of cPanel when finished.

Common Errors

Import File Too Large

The database backup exceeds the server's upload limit.

Possible solutions include:

Compressing the SQL file
Splitting the database into smaller files
Contacting your hosting provider for assistance

SQL Syntax Errors

Verify that:

SQL commands are correctly written.
Table names exist.
Special characters are properly escaped.

Missing Tables

Ensure you are viewing the correct database and that the database import completed successfully.

Conclusion

phpMyAdmin is a powerful tool that allows you to manage MySQL and MariaDB databases directly from cPanel. Whether you need to browse records, run SQL queries, import backups, or export databases, phpMyAdmin provides a convenient interface for database administration without requiring command-line access.

Always create a backup before making database changes to ensure that your data can be restored if necessary.

Categories