MySQL Admin: Difference between revisions
Helen Foster (talk | contribs) (see also link, link edit) |
|||
| (15 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. | |||
This is a powerful program that should be used with care and be available only to trusted administrators. | |||
==Install phpMyAdmin in Moodle 1.9.x or earlier== | |||
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 to assist with the Moodle install. | |||
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 | |||
==Install phpMyAdmin in Moodle 2.0 or later== | |||
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/local/'' folder. You should end up with a folder there called 'phpmyadmin' 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 to assist with the Moodle install. | |||
For more advanced users: To obtain the most recent version from git, go to the ''moodle/local/'' folder and run | |||
git clone git://github.com/moodlehq/moodle-local_phpmyadmin.git phpmyadmin | |||
==See also== | ==See also== | ||
| Line 5: | Line 27: | ||
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=56636 Remove database access] forum discussion | *Using Moodle [http://moodle.org/mod/forum/discuss.php?d=56636 Remove database access] forum discussion | ||
[[Category:Administrator]][[Category:SQL databases]] | |||
[[Category:Administrator]] | |||
[[Category:SQL | |||
Latest revision as of 02:38, 14 February 2011
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.
This is a powerful program that should be used with care and be available only to trusted administrators.
Install phpMyAdmin in Moodle 1.9.x or earlier
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 to assist with the Moodle install.
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
Install phpMyAdmin in Moodle 2.0 or later
To install phpMyAdmin so it is directly available via Moodle, unzip the archive from Modules and plugins database inside the moodle/local/ folder. You should end up with a folder there called 'phpmyadmin' 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 to assist with the Moodle install.
For more advanced users: To obtain the most recent version from git, go to the moodle/local/ folder and run
git clone git://github.com/moodlehq/moodle-local_phpmyadmin.git phpmyadmin
See also
- Using Moodle Remove database access forum discussion
