phpMyAdmin is a web-based tool for managing MySQL databases. You can use it to create tables, run SQL queries, import and export data, and manage database users. This guide covers how to access and use phpMyAdmin in Plesk.
Accessing phpMyAdmin
- Log in to Plesk.
- Go to Databases.
- Click the database you want to manage.
- Click Webadmin (or phpMyAdmin).
- phpMyAdmin will open in a new tab, logged in with the database user credentials.
Accessing phpMyAdmin for All Databases
- Go to Databases.
- At the top of the page, click the phpMyAdmin icon (or link).
- This opens phpMyAdmin with access to all databases on your account.
Common phpMyAdmin Operations
- Browse tables: Click a database in the left sidebar, then click a table to view its contents.
- Run SQL queries: Click the SQL tab, enter your query, and click Go.
- Import data: Click Import, select a
.sqlfile, and click Go. - Export data: Click Export, choose Quick or Custom, and click Go to download.
- Create a table: Click a database, enter a table name and number of columns, and click Go.
- Repair a table: Click a table, go to the Operations tab, and click Repair table.
- Optimize a table: Click a table, go to Operations, and click Optimize table.
Important Notes
- When you open phpMyAdmin from Plesk, it automatically logs you in — no manual login required.
- Be cautious when running SQL queries — a mistake can permanently modify or delete data.
- Always back up your database before making changes.
Troubleshooting
phpMyAdmin link is missing:
- Contact your hosting provider — phpMyAdmin may not be installed or enabled.
"Access denied" in phpMyAdmin:
- Try accessing it again from Databases in Plesk to refresh the login session.
