Adminer Local Database Management Guide
A single-file PHP database tool, Adminer can be deployed at http://localhost/adminer to manage MySQL, MariaDB, SQLite, and more.
Adminer (originally phpMinAdmin) is a database management tool consisting of just one PHP file. It functions similarly to phpMyAdmin but is smaller in size and easier to deploy, making it suitable for quick local management of MySQL/MariaDB.
Access Address
After placing adminer.php in the web root directory:
| Deployment Path | Address |
|---|---|
htdocs/adminer.php | http://localhost/adminer.php |
htdocs/adminer/index.php | http://localhost/adminer |
Installation Steps
- Download
adminer.phpfrom adminer.org (optional MySQL specific version). - Copy it to
XAMPP htdocs/adminer/and rename it toindex.php, or place the single file inhtdocs/adminer.php. - Ensure Apache and MySQL/MariaDB are running.
- Open the above address in your browser.
Login Interface
| Field | Typical Local Value |
|---|---|
| System | MySQL |
| Server | localhost |
| Username | root |
| Password | Empty or your local password |
| Database | Leave empty (select after login) or specify a database name |
Comparison with phpMyAdmin
| Feature | Adminer | phpMyAdmin |
|---|---|---|
| Size | Single file ~500KB | Full package |
| Deployment | Copy one file | Extract entire directory |
| Functionality | Create databases, SQL, import/export | More comprehensive features, plugin ecosystem |
For small local projects or temporary environments, Adminer is lighter; XAMPP users typically already have phpMyAdmin included.
Frequently Asked Questions
Blank page or 500 error
Ensure PHP is enabled and the version meets the requirements; check the PHP error log.
Unable to connect to the database
MySQL service is not running; server should be localhost; verify the root password.
Summary
Adminer requires only one PHP file, and by accessing http://localhost/adminer, you can manage local MySQL/MariaDB, making it a lightweight alternative to phpMyAdmin.