phpMyAdmin

Summary

The phpMyAdmin interface can be used as a tab in the project interface.

phpMyAdmin requires the LAMP, MySQL 5.7, or MySQL 8.0 stack.

phpMyAdmin is not supported by Safari.

Features

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:

A database administration tool built for MySQL

  • Syntax highlighting, code completion, and smart indentation

  • Execute SQL queries against any database

  • Format SQL queries

Work with datasets with ease

  • 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

Advanced database administration features

  • 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!

Getting Started

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.