try.directtry.direct

Back to explains list

phpMyAdmin

phpMyAdmin is a free and open-source software tool that is easy to set up. It is created for MySQL or MariaDB database server administration and supports most database management system operations. You can manage databases, tables, columns, indexes, users, relations, permissions, and others via the intuitive web interface or directly execute any SQL statement.

phpMyAdmin has a stable and flexible codebase created by multiple contributors from the global PHP community.


Features:

  • CSV and SQL data import
  • CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, LATEX data export
  • Multiple servers administration
  • Query-by-example (QBE)
  • InnoDB tables and MySQLi support
  • User permissions management
  • Foreign keys support
  • MySQL features support:
  • databases, tables, fields, and indexes maintenance, creation, browsing, copying, dropping, remaining and altering
  • SQL-statement, incl. even batch-queries execution, edition, and bookmark
  • MySQL user accounts and privileges management
  • stored procedures and triggers management
  • database layout graphics creation
  • Query-by-example (QBE) complex queries creation
  • Global database search

For security purposes, TryDirect recommends that you first stop (pause) the phpMyAdmin container and then start it as necessary. This can be done by using Portainer or the Status Panel.



Deploy LAMP stack with phpMyAdmin included for free


Documentation

Official documentation

Next article: Find the public IP address from the terminal