What Is phpMyAdmin
phpMyAdmin is a web-based tool for managing MySQL databases through a graphical interface. It allows you to browse tables, run SQL queries, import and export data, and manage database structure without using the command line.
How to Access phpMyAdmin
- Log in to DirectAdmin.
- Navigate to Account Manager or System Info & Files.
- Click on phpMyAdmin.
- You will be redirected to the phpMyAdmin login page (or logged in automatically).
- If prompted, enter your database username and password.
- Click Go to log in.
Some DirectAdmin configurations provide automatic single sign-on to phpMyAdmin. If you are prompted for credentials, use the database username and password you created when setting up your database, not your DirectAdmin login.
Navigating phpMyAdmin
The phpMyAdmin interface has the following key areas:
- Left Sidebar - Lists all databases you have access to. Click a database name to expand and see its tables.
- SQL Tab - Run custom SQL queries directly against the selected database.
- Structure Tab - View and modify the table structure (columns, indexes, keys).
- Browse Tab - View the data stored in a table with pagination.
- Insert Tab - Manually add new rows of data to a table.
- Import Tab - Import SQL files or other data formats into the database.
- Export Tab - Export the database or specific tables to SQL, CSV, or other formats.
- Operations Tab - Rename, copy, or optimize tables.
Basic Operations
- View table data - Click a table name in the sidebar, then click Browse.
- Edit a record - While browsing data, click the Edit link next to any row.
- Delete a record - Click the Delete link next to a row. Confirm the deletion.
- Run a query - Click the SQL tab, type your query, and click Go.
- Search data - Use the Search tab to find specific records across tables.
Be very careful when modifying data directly in phpMyAdmin. There is no undo function. Deleting or modifying the wrong records can break your website. Always create a backup before making changes.