The phpMyAdmin interface can be used as a tab in the project interface.
phpMyAdmin includes some powerful SQL capabilities including the ability to create databases, modify database schemas, and add/modify/delete rows in tables. Here are some of its top features:
Syntax highlighting, code completion, and smart indentation
Execute SQL queries against any database
Format SQL queries
Switch between databases using the GUI interface
Import data from CSV and SQL
Export data to CSV, SQL, XML, PDF, Word, and more
Integrated help and documentation
Search globally in a database or a subset of it
Manage MySQL user accounts and privileges
Create complex queries using Query-by-example (QBE)
See here for more features!
To get started first perform the initial setup for a MySQL lesson as described here. Then create a phpMyAdmin tab.
Next create the database(s) and database tables that you'd like the user to have when they start the lesson. If you have an SQL file that contains the commands to create the database, you can use the "Import" tab to upload the .sql file, then click "Go" at the bottom right of the page to execute the SQL statements in the file.
Finally, be sure to click the Save button when you are done! This is required to persist the configuration changes you have made.