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

Adminer: Difference between revisions

From MoodleDocs
Main page ► Managing a Moodle site ► Adminer
Managing a Moodle site
(→‎Install phpMyAdmin: Add alternatives to phpMyAdmin location)
m (changed the current version to reflect actual state)
 
(9 intermediate revisions by 7 users not shown)
Line 1: Line 1:
'''phpMyAdmin''' is a useful MySQL database administration tool (if you are using MySQL as the database for your Moodle). 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.
{{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''.


==Install phpMyAdmin==
This is a powerful program that should be used with care and be available only to trusted administrators.
To install phpMyAdmin so it is directly available via Moodle, unzip the archive from [http://moodle.org/mod/data/view.php?d=13&rid=448 Modules and plugins database] inside the ''moodle/admin'' folder. You should end up with a folder there called 'mysql'  which contains all the necessary files.  Now go to your site admin block and you will see a new link: ''Server > Database''. Use this link to initially install and/or open phpMyAdmin.


For those that need phpMyAdmin to perform a Moodle install, unpack it in the documents directory (the same directory as your moodle folder, sometimes found in the folder htdocs) of your web server. Note: many web hosting sites have phpMyAdmin already available via their control panel, you can use that.
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''


For more advanced users: To obtain the most recent version from CVS, go to the ''moodle/admin'' folder and run
Anyone using PHPMyAdmin is recommended to switch to Adminer.


cvs -z3 -d:ext:myusername@cvs.moodle.org:/cvsroot/moodle co mysql
[[Category:Contributed code]]
[[Category:SQL databases]]


==See also==
[[es:Adminer]]
 
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=56636 Remove database access] forum discussion
 
[[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/32/en/index.php?title=Adminer&oldid=116858"
Powered by MediaWiki