Moodle plugins directory: Moodle Adminer | Moodle.org
Moodle Adminer
General plugins (Local) ::: local_adminer
Maintained by 
Andreas Grabs
This plugin is based on the great tool adminer.
The main advantage of this plugin is, it can handle different types of database. So it works with MySQL/MariaDB, PostgreSQL, Oracle and MSSQL.
Latest release:
4394 sites
2k downloads
111 fans
Current versions available: 10
This plugin is based on the great tool adminer.
The main advantage of this plugin is, it can handle different types of database.
So it works with:
- MySQL/MariaDB
- PostgreSQL
- Oracle
- MSSQL
Here are some of the key-features:
- you can define trigger
- you can change the order of fields
- you can easy create or alter views
- you can create stored procedures
- if you rename a database so the database is altered and not copied like phpMyAdmin it does
- you can define foreign key with referential integrity
To install it you only have to copy it into the "local" folder in your moodle-installation and call the notification-page. After the installation you will find a new link "Moodle Adminer" below "Site administration / Server".
Useful links
Screenshots
Contributors
Andreas Grabs (Lead maintainer)
Please login to view contributors details and/or to contact them
Awards
Comments 
Comments
Please login to post comments
This is working great on my 2.4+ site. When do you expect a version out for 2.5?
Best regards
Andreas
I must admit a security issue did come up, but I am hoping it can be fixed so that only the Admin User has rights to access it, if it can be done that way. If it can then I am going to have a discussion with a number of people about how useful it can be. I am thinking here of just how much easier it will be to restore deleted users. Thank you.
Mi, 19. Nov 2014, 00:01
Sorry for the long waiting. Now I updated the adminer plugin. The moodle part has no big changes. The adminer now is based on 4.1.0
Please check and fix it if appropiate.
Thanks.
Yet you can simple integrate it in your repository by merging it. Use the steps below:
1. Go into your moodle repository
2. # git remote add adminer git://github.com/grabs/moodle-local_adminer.git
3. # git fetch adminer
4. # git merge adminer/v_27
That's it.
Best regards
Andreas
Do you plan to make Adminer officially compatible with Moodle 2.9, so that it can be installed/upgraded via the build in installer?
Best regards Andreas
Thanks for adminer; for my I prefer it to tools like MySQL workbench for my limited needs to interact with the database directly.
I've just come across an issue where adminer showed a blank page when launched. Debugging showed that run_adminer.php could access adminer.php. Our anti virus solution had decided that adminer.php was a 'hacking tool' and quarantined it. I suspect it interpreted the name as 'ad miner'. Just in case someone else has this issue.
Christoph