Using phpMyAdmin in DirectAdmin

phpMyAdmin is a web-based tool for managing MySQL databases. It provides a graphical interface for running SQL queries, browsing tables, importing and exporting data, and managing database structure.

Accessing phpMyAdmin

1. Log in to DirectAdmin
2. Navigate to Account Manager or Your Account
3. Click phpMyAdmin (or access it through MySQL Management > phpMyAdmin link)
4. You will be logged into phpMyAdmin automatically via SSO

Tip: If phpMyAdmin does not load, try clearing your browser cache or using an incognito window.

Navigating the Interface

Left Panel

• Shows all your databases
• Click a database name to expand and see its tables
• Click a table name to browse its data

Top Navigation

• SQL — Run custom SQL queries
• Import — Upload and import SQL files
• Export — Download database backups
• Operations — Rename, copy, or optimize tables
• Search — Search across all tables

Common Tasks

Browse and Edit Data

1. Select your database from the left panel
2. Click on a table name
3. The Browse tab shows all rows
4. Click Edit next to any row to modify it
5. Click Delete to remove a row
6. Use Insert tab to add new rows

Run SQL Queries

1. Select your database
2. Click the SQL tab
3. Enter your query in the text area:

SELECT * FROM users WHERE status = 'active' ORDER BY created_at DESC LIMIT 50;

1. Click Go to execute

Create a New Table

1. Select your database
2. Under "Create table," enter the table name and number of columns
3. Click Go
4. Define each column: name, type, length, default value, index, etc.
5. Click Save

Search Across Tables

1. Select your database
2. Click the Search tab
3. Enter your search term
4. Select which tables to search
5. Click Go to find matching records

Importing Data

1. Select the target database
2. Click Import
3. Click Choose File and select your .sql or .csv file
4. Set the format (usually auto-detected)
5. Click Go

File size limit: phpMyAdmin typically supports uploads up to 50 MB. For larger files, import via SSH.

Exporting Data

1. Select the database (or specific tables)
2. Click Export
3. Choose export method:

- Quick — Downloads the entire database with default settings

- Custom — Lets you choose specific tables, format options, and compression

1. Format is usually SQL for backups
2. Click Go to download

Tip: Always export a backup before making structural changes to your database.

Optimizing Tables

Over time, tables can become fragmented. To optimize:

1. Select your database
2. Check the tables you want to optimize
3. From the dropdown at the bottom, select Optimize table
4. Click Go

Troubleshooting

phpMyAdmin Shows Blank Page

• Clear your browser cache and cookies
• Try accessing in an incognito window
• Disable browser extensions that may interfere

Import Fails with Timeout

• Split your SQL file into smaller parts
• Use SSH for large imports instead

Cannot Delete or Modify Rows

• Ensure the table has a primary key defined
• Check that your database user has the required privileges

Related Articles

• Creating MySQL Databases in DirectAdmin
• DirectAdmin Dashboard Overview

Need help? Contact our support team at {{SUPPORT_EMAIL}} or open a ticket at {{SUPPORT_URL}}.