What is phpMyAdmin?

phpMyAdmin is a web-based tool for managing MySQL/MariaDB databases. You can browse tables, run SQL queries, import/export data, and more.

Accessing phpMyAdmin

  1. Log in to DirectAdmin
  2. Go to Account ManagerMySQL Management (or Databases)
  3. Click the phpMyAdmin link (or button)
  4. You'll be logged in automatically to phpMyAdmin

Common Tasks

Import a Database

  1. Select the database in the left sidebar
  2. Click the Import tab
  3. Choose your .sql file
  4. Click Go

Export a Database

  1. Select the database
  2. Click the Export tab
  3. Choose Quick export, format SQL
  4. Click Go — your browser will download the .sql file

Run a SQL Query

  1. Select the database
  2. Click the SQL tab
  3. Enter your query
  4. Click Go
Tip: Always make a backup (export) before running DELETE or UPDATE queries.