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)

EnvironmentDefault URLNotes
XAMPPhttp://localhost/phpmyadminOften htdocs/phpmyadmin/
WAMPhttp://localhost/phpmyadminOften www/phpmyadmin/
LAMP / custom Apachehttp://localhost/phpmyadminInstall under the web root
MAMP (default ports)http://localhost:8888/phpMyAdminPath 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

FieldTypical local value
Usernameroot
Password (XAMPP / many WAMP setups)empty
Password (MAMP)often root
Server / hostlocalhost or 127.0.0.1

Create empty databases here before installing WordPress, Moodle, or Joomla.

Common tasks

  1. New database: Databases → name → collation utf8mb4_unicode_ci
  2. Import SQL: select DB → Import → .sql file
  3. Export: Export → Quick or Custom
  4. Run SQL: SQL tab

Also see MySQL, MariaDB, Adminer.

Troubleshooting

404 Not Found

  1. Apache not running → Start it in XAMPP/WAMP
  2. Wrong folder → expect htdocs/phpmyadmin/ (or www/…)
  3. Wrong port → on MAMP try :8888/phpMyAdmin
  4. Case sensitivity → phpmyadmin vs phpMyAdmin on macOS/Linux

Access denied / cannot log in

  1. MySQL/MariaDB not running
  2. Wrong password (try empty on XAMPP; root on MAMP)
  3. Check $cfg['Servers'] in config.inc.php
  4. Try host 127.0.0.1 instead of localhost

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 = 300

Or import via CLI:

mysql -u root -p your_database < backup.sql

Manual install (no stack package)

  1. Download from phpmyadmin.net
  2. Extract to the web root as phpmyadmin
  3. Copy config.sample.inc.phpconfig.inc.php and set $cfg['blowfish_secret'] plus server credentials
  4. 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.

访客计数:------ Best viewed in Netscape Navigator · 800×600 © LocalHost Run