localhost/phpmyadmin Not Working? Default URLs & Fixes
Open http://localhost/phpmyadmin to manage MySQL/MariaDB. Default XAMPP/WAMP/MAMP URLs, login credentials, and fixes for 404, access denied, and failed imports.
When you type http://localhost/phpmyadmin, localhost/phpmyadmin, or search phpmyadmin localhost, you usually want the local MySQL/MariaDB web UI. phpMyAdmin ships with XAMPP, WAMP, and MAMP and is the most common local database console.
Default URLs (match your stack)
| Environment | Default URL | Notes |
|---|---|---|
| XAMPP | http://localhost/phpmyadmin | Often htdocs/phpmyadmin/ |
| WAMP | http://localhost/phpmyadmin | Often www/phpmyadmin/ |
| LAMP / custom Apache | http://localhost/phpmyadmin | Install under the web root |
| MAMP (default ports) | http://localhost:8888/phpMyAdmin | Path case is often phpMyAdmin; port may be 8888 |
Related queries pointing at the same intent: http://localhost/phpmyadmin/, localhost phpmyadmin, phpmyadmin/localhost.
Start Apache and MySQL/MariaDB in the control panel before opening the URL.
Login defaults
| Field | Typical local value |
|---|---|
| Username | root |
| Password (XAMPP / many WAMP setups) | empty |
| Password (MAMP) | often root |
| Server / host | localhost or 127.0.0.1 |
Create empty databases here before installing WordPress, Moodle, or Joomla.
Common tasks
- New database: Databases → name → collation
utf8mb4_unicode_ci - Import SQL: select DB → Import →
.sqlfile - Export: Export → Quick or Custom
- Run SQL: SQL tab
Also see MySQL, MariaDB, Adminer.
Troubleshooting
404 Not Found
- Apache not running → Start it in XAMPP/WAMP
- Wrong folder → expect
htdocs/phpmyadmin/(orwww/…) - Wrong port → on MAMP try
:8888/phpMyAdmin - Case sensitivity →
phpmyadminvsphpMyAdminon macOS/Linux
Access denied / cannot log in
- MySQL/MariaDB not running
- Wrong password (try empty on XAMPP;
rooton MAMP) - Check
$cfg['Servers']inconfig.inc.php - Try host
127.0.0.1instead oflocalhost
Blank page / endless spinner
Check Apache/PHP error logs; confirm PHP version matches phpMyAdmin requirements.
Large import fails
Raise limits in php.ini, restart Apache:
upload_max_filesize = 128M
post_max_size = 128M
max_execution_time = 300Or import via CLI:
mysql -u root -p your_database < backup.sqlManual install (no stack package)
- Download from phpmyadmin.net
- Extract to the web root as
phpmyadmin - Copy
config.sample.inc.php→config.inc.phpand set$cfg['blowfish_secret']plus server credentials - Open http://localhost/phpmyadmin
Summary
Default entry is http://localhost/phpmyadmin (MAMP often uses a port + phpMyAdmin). If it fails, check services → folder → port/case → root password.