Difference between revisions of "Adminer"

Jump to: navigation, search

Note: You are currently viewing documentation for Moodle 3.4. Up-to-date documentation for the latest stable version of Moodle is likely available here: Adminer.

(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.