Note: You are currently viewing documentation for Moodle 2.9. Up-to-date documentation for the latest stable version of Moodle may be available here: Adminer.

Adminer: Difference between revisions

From MoodleDocs
Main page ► Managing a Moodle site ► Adminer
Managing a Moodle site
(grr about moodle database but this works for a newuser)
m (changed the current version to reflect actual state)
 
(12 intermediate revisions by 9 users not shown)
Line 1: Line 1:
[[MySQL]] and [[PostgreSQL]] are the two fully supported databases that Moodle uses. Other databases may also work.
{{Managing a Moodle site}}
Moodle Adminer is a useful database administration tool. It works with MySQL, PostgreSQL, Oracle and MSSQL. When installed as part of Moodle, it becomes part of the Moodle interface and a link can be found in ''Settings > Site administration > Server''.


'''phpMyAdmin''' is a useful MySQL database administration tool. When installed as part of Moodle, it becomes part of the Moodle interface. It can be found in the site administration block>Server>database link.   
This is a powerful program that should be used with care and be available only to trusted administrators.   


==Install phpMyAdmin==
Adminer is available for download from the Moodle plugins directory: http://moodle.org/plugins/view.php?plugin=local_adminer ''Note: it is currently (February 2015) released for 2.8''
phpMyAdmin can downloaded from the [http://moodle.org/mod/data/view.php?d=13&rid=448 Modules and plugins database].


To install, just unzip the archive inside the ''moodle/admin'' folder. You should end up with a folder in there called 'mysql' in there that contains all the necessary files. Now when you look at your site admin block you will see a new link: ''Server > Database''.
Anyone using PHPMyAdmin is recommended to switch to Adminer.


==See also==
[[Category:Contributed code]]
[[Category:SQL databases]]


*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=56636 Remove database access] forum discussion
[[es:Adminer]]
 
[[Category:Administrator]][[Category:SQL databases]]

Latest revision as of 11:43, 4 February 2015

Moodle Adminer is a useful database administration tool. It works with MySQL, PostgreSQL, Oracle and MSSQL. When installed as part of Moodle, it becomes part of the Moodle interface and a link can be found in Settings > Site administration > Server.

This is a powerful program that should be used with care and be available only to trusted administrators.

Adminer is available for download from the Moodle plugins directory: http://moodle.org/plugins/view.php?plugin=local_adminer Note: it is currently (February 2015) released for 2.8

Anyone using PHPMyAdmin is recommended to switch to Adminer.

Retrieved from "https://docs.moodle.org/29/en/index.php?title=Adminer&oldid=116858"
Powered by MediaWiki