Adminer
MySQL and PostgreSQL are the two fully supported databases that Moodle uses. Other databases may also work.
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.
Install phpMyAdmin
phpMyAdmin can downloaded from the 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.
See also
- Using Moodle Remove database access forum discussion