Adminer is one of the useful database administration tool which allows the web administrators to manage their databases easily. Managing MySQL databases is one of the fundamental requirements of being a professional WordPress developer. Adminer simplifies that task immensely. In this post we will see how you can utilize the power of Adminer in Moodle LMS.
The Moodle Adminer plugin allows you to manage your Moodle database easily through the web interface. You can access your Moodle database right within Moodle web interface. With the Moodle Adminer plugin you will not need to use the PHPMyAdmin which is the generally used web interface tool to manage the databases.
Moodle Adminer plugin can work with different types of database like MySQL/MariaDB, PostgreSQL, Oracle and 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.
You can download the Moodle Adminer plugin from the official plugins repository here. Once installed, you can access and update your database table through Site Admin > Server > Moodle Adminer.
The plugin is one of the most actively maintained Moodle plugin over the years and has received the Moodle 4.3 Early Bird badge recently.
What are the other useful Admin plugins you are using on your Moodle site? Please share with us in the comments section below.
For regular updates about Moodle, eLearning and edtech industry, please visit us regularly at https://lmsdaily.com. You can also like us on Facebook or follow us on Twitter, or Subscribe our YouTube Channel.
