phpMyAdmin

phpMyAdmin is a web tool for managing MySQL/MariaDB databases. It is available from cPanel and needs no extra login.

Opening it#

In cPanel open Databases → phpMyAdmin. The left column lists your databases; click one to see its tables.

Most common tasks#

• Viewing data: click a table, then the Browse tab.
• Searching: the Search tab lets you filter by columns.
• Running a query: the SQL tab. Type the query and click Go.
• Editing a row: in Browse click Edit next to the row, change the value and save.
• Table structure: the Structure tab shows columns and indexes.
• Import and export: the Import and Export tabs, see Importing and exporting a database.

Example: changing the site address in a WordPress database (adjust the table prefix and address):

UPDATE wp_options
SET option_value = 'https://yourdomain.com'
WHERE option_name IN ('siteurl', 'home');