phpMyAdmin

phpMyAdmin is intended to handle the administration of MySQL over the Web. Currently it can:

• Create and drop databases
• Create, copy, drop, and alter tables
• Delete, edit, and add fields
• Execute any SQL-statement, even batch-queries
• Manage keys on fields
• Load text files into tables
• Create and read dumps of tables
• Export data to CSV values
• Administer multiple servers and single databases

• Many security fixes of various levels of severity
• There have been changes in the behavior of previous version:
• Changed the suggested text in the query window for delete queries to avoid accidental data loss
• Re-introduce a page which shows the output of phpinfo()

Bug Fixes:

• Parsing of SQL queries with the BINARY function
• Syntax error when adding or changing TIMESTAMP columns with default value as NULL
• Broken "Edit" and "Export" links in the Routines tab
• Creating a new user on older MariaDB servers
• Format button in the SQL tab broken
• Fixes for PHP 7.1
• Problems with MySQL servers running with `lower_case_names=2`
• Fixes for several PHP notices/warnings being shown