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.
Login
- Username: Usually
root - Password: Default may be empty for XAMPP/WAMP; commonly
rootfor MAMP - Server:
localhost
Common Operations
- Create Database: “Databases” → Enter name → Select
utf8mb4_unicode_ci - Import SQL: Select database → “Import” → Choose
.sqlfile - 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.phptoconfig.inc.phpand 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.