Jun 2, 2026 · Databases · 1min read

phpMyAdmin Local Usage Guide

Manage MySQL/MariaDB databases in your browser at http://localhost/phpmyadmin, create tables, and import/export SQL.

phpMyAdmin is a web-based management tool for MySQL/MariaDB, pre-installed with packages like XAMPP, WAMP, and MAMP, and is the most commonly used database management interface in local development.

Default Access Address

Environment	Address
XAMPP / WAMP / LAMP	http://localhost/phpmyadmin
MAMP (default port)	http://localhost:8888/phpMyAdmin

Note that in MAMP, the path may be case-sensitive and appear as phpMyAdmin.

Username: Usually root
Password: Default may be empty for XAMPP/WAMP; commonly root for MAMP
Server: localhost

Common Operations

Create Database: “Databases” → Enter name → Select utf8mb4_unicode_ci
Import SQL: Select database → “Import” → Choose .sql file
Export Backup: “Export” → Quick or custom export
Execute SQL: Run statements directly in the “SQL” tab

Before installing CMSs like WordPress or Drupal, it’s common to create an empty database in phpMyAdmin.

Manual Installation (Without Integrated Package)

Download from phpmyadmin.net
Extract to web root directory phpmyadmin/
Copy config.sample.inc.php to config.inc.php and configure
Access http://localhost/phpmyadmin

Common Issues

Unable to Login / Access Denied
Ensure MySQL/MariaDB is running; verify username and password; check $cfg['Servers'] configuration in config.inc.php.

404 Not Found
Confirm the files are in htdocs/phpmyadmin/ (or corresponding web root); ensure Apache is running.

Failed to Import Large Files
Increase upload_max_filesize and post_max_size in php.ini, or use the command line mysql for import.

Summary

In local development, http://localhost/phpmyadmin is the default entry point for managing MySQL/MariaDB, suitable for creating CMS databases and debugging SQL.