Note: You are currently viewing documentation for Moodle 1.9. Up-to-date documentation for the latest stable version is available here: MySQL Admin.

MySQL Admin

From MoodleDocs
Revision as of 13:11, 13 September 2010 by chris collman (talk | contribs) (→‎Install phpMyAdmin: Add alternatives to phpMyAdmin location)

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.

Install phpMyAdmin

To install phpMyAdmin so it is directly available via Moodle, unzip the archive from 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.

For more advanced users: To obtain the most recent version from CVS, go to the moodle/admin folder and run

cvs -z3 -d:ext:myusername@cvs.moodle.org:/cvsroot/moodle co mysql

See also