What is Adminer and what does it do?
Adminer is a lightweight, single-file PHP tool for managing SQL databases. It supports multiple database systems including PostgreSQL, SQLite, MySQL, and Oracle.
Beginner
🚀 Getting Started
How do I install Adminer?
Adminer is a single PHP file ready for immediate use. Simply download it from the download page and place it on a web server supporting PHP. No installation is required.
Quick Start
Can I run Adminer locally?
Yes! Adminer works well with local servers like XAMPP or Docker. Just upload the Adminer file to your local server and access it in your browser.
Local Use
🔐 Security
Is Adminer secure to use in production?
Adminer includes strong security features, but it's recommended to place it in a secure subdirectory and protect it with additional measures like authentication and HTTPS.
Security
How do I protect Adminer from unauthorized access?
For added security, consider using HTTP authentication, placing Adminer in a subdirectory, and enabling HTTPS to protect against session hijacking.
Best Practices
Can Adminer manage database permissions?
Yes, Adminer allows managing user privileges including granting and revoking permissions for database users.
Permissions
🛠 Troubleshooting
My database connection fails. What should I check?
Confirm the database host, port, username, password, and database name in the Adminer configuration. Also, verify that PDO drivers for your database are installed and enabled.
Connection
Adminer doesn't show my database tables.
Ensure that you have selected the correct database from the dropdown list at the top of the Adminer interface. Some database systems may require specific permissions to view schema information.
Schema
How do I debug SQL queries using Adminer?
Use the raw SQL query interface available after connecting to your database. Execute and test your queries directly in the query executor to debug syntax and logic errors.
Queries
⚙️ Advanced Usage
How do I customize Adminer with plugins?
Adminer supports plugin architecture through its PHP-based system. Look at the official plugin repository or develop custom plugins to extend functionality.
Plugins
What database systems are supported?
Adminer supports MySQL, PostgreSQL, SQLite, Oracle, Microsoft SQL Server, and many others. Check our documentation for the complete list of supported database backends.
Backend
Can I schedule tasks with Adminer?
Adminer itself doesn't include scheduling functionality, but you can use native database features like PostgreSQL's pgAgent or MySQL's event scheduler for automated tasks.
Scheduling
🤝 Need Help?
Still have questions? Check out our documentation, or contact our support team for help with any issues you may be experiencing.