Comment on page
phpMyAdmin
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.
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)
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.
Last modified 2yr ago