How to open phpMyAdmin in ISPmanager

phpMyAdmin is a web interface for MySQL databases. You can browse tables, fix a record, run an SQL query, export or import data. The panel opens phpMyAdmin already logged in: no need to enter the database user password.

Open phpMyAdmin

  1. "Databases".
  2. Three dots on the database → "Database web-interface". Or tick the database and click "Database web-interface" on the top toolbar.
Database menu
Database menu

phpMyAdmin opens in a new tab and logs you in.

phpMyAdmin
phpMyAdmin

Databases are on the left. Click a database to see its tables.

What you can do

TaskWhere
Browse and edit dataclick a table, then "Edit" on a row
Run a querythe "SQL" tab
Find text in the whole databasethe "Search" tab at database level
Export or import the databasethe "Export" and "Import" tabs
Check and repair tableschecking tables

Example: the WordPress site address

If after a domain change or enabling HTTPS WordPress keeps redirecting to the old address, fix it in the "SQL" tab. Your table prefix may differ from wp_ — check it in the table list.

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

Changes in phpMyAdmin apply immediately, there is no "Undo". Before deleting or bulk editing, export the database: export.

Create new databases and users in the panel, not in phpMyAdmin. The phpMyAdmin session expires after a while — open it again from the panel.

Questions and answers
Three dots on the database → "Database web-interface". You are logged in automatically.
The session expired. Open phpMyAdmin from the panel again.
Yes, in the language field on the phpMyAdmin home page.