Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
To download, install, and start using the PHPMyAdmin tool to give you direct access to the Moodle database, follow these steps:
Download the latest version of the PHPMyAdmin tool from the Modules and Plugins page on Moodle.org.
Search for PHPMyAdmin, click on the Name link and then on the Download latest version link found at the bottom-right of the plugin explanation page. (Note, the plugin title on Moodle.org is MySQL Admin)
Unzip the downloaded package and place the directory, titled mysql, in the admin directory of your Moodle site located at /yourmoodleroot/admin.
Log in to your site as admin and click on the Server link found in the Site Administration block.
A Database link should appear at the bottom of the list of items under the Server category. Click on the Database link to access the PHPMyAdmin tool, as shown in the following screenshot (Note, if you were already logged in as admin when you installed the package, you may need to refresh your browser window to get the Database link to appear).
Each of the lines shown on the left side of the window represents a table in the Moodle database. The database that our example Moodle installation is running on contains 223 tables, as shown in parentheses at the top-left of the screen next to the database name in the previous screenshot. Click on one of the tables, mdl_block, for example, to view the Structure window for that table, as shown in the following screenshot: