phpMyAdmin is a browser-based tool for managing MySQL databases. You can view and edit tables, run SQL queries, import and export data, and fix database errors β all without using the command line.
Opening phpMyAdmin
In cPanel, go to Databases > phpMyAdmin. It opens in a new tab. The left panel lists all your databases β click one to expand it and see its tables.
Browsing and Editing Data
Click a table name to browse its rows. Click Edit on any row to modify values directly. This is useful for tasks like changing a WordPress admin email or resetting a plugin setting.
Running SQL Queries
Click the SQL tab to enter and run custom queries. Example β search WordPress users:
SELECT user_login, user_email FROM wp_users;Import and Export
Use Export to download a full database backup as a .sql file. Use Import to restore a backup or migrate data from another server. Keep exported files in a secure location.