Sign In

Welcome! Log into your account

Forgot your password?

Create an account

Sign Up

Welcome! Register for an account

A password will be e-mailed to you.

Password Recovery

Recover your password

A password will be e-mailed to you.

phpMyAdmin 5.0.4 / 4.9.7 / 5.1.0 Snapshot 2020-11-08

1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 4.33 out of 5)
phpMyAdmin 5.0.4 / 4.9.7 / 5.1.0 Snapshot 2020-11-08

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB.

Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) you acn perform via the user interface. But you still have the ability to directly execute any SQL statement.

phpMyAdmin comes with a wide range of documentation and users are welcome to update the wiki pages to share ideas and howtos for various operations. The phpMyAdmin team will try to help you if you face any problem. You can use a variety of support channels to get help.

phpMyAdmin is also very deeply documented in a book written by one of developers. Mastering phpMyAdmin for Effective MySQL Management, which is available in English and Spanish.

phpMyAdmin is a mature project with a stable and flexible code base. It has won several awards. Translated into 72 languages and supports both LTR and RTL languages.

phpMyAdmin Features:

  • Intuitive web interface
  • Support for most MySQL features:
    • browse and drop databases, tables, views, fields and indexes
    • create, copy, drop, rename and alter databases, tables, fields and indexes
    • maintenance server, databases and tables, with proposals on server configuration
    • execute, edit and bookmark any SQL-statement, even batch-queries
    • manage MySQL user accounts and privileges
    • manage stored procedures and triggers
  • Import data from CSV and SQL
  • Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 – OpenDocument Text and Spreadsheet, Word, LATEX and others
  • Administering multiple servers
  • Creating graphics of your database layout in various formats
  • Creating complex queries using Query-by-example (QBE)
  • Searching globally in a database or a subset of it
  • Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
  • And much more…

Changes in phpMyAdmin 5.0.4 (2020-10-15):

  • Two factor authentication was broken
  • Incompatibilities with older PHP versions.

Changes in phpMyAdmin 5.0.3 (2020-10-10):

Several important security fixes:

  • PMASA-2020-5 XSS vulnerability with transformation feature
  • PMASA-2020-6 SQL injection vulnerability with the search feature

In addition, 5.0.3 contains many bugfixes. Some of the highlights include:

  • Fix an error message about htmlspecialchars() when attempting to export XML
  • Support double tapping to edit on mobile
  • Fix the error message “Use of undefined constant MYSQLI_TYPE_JSON” when using mysqlnd
  • Fix fatal JS error on index creation after using Enter key to submit the form
  • Fix “axis-order” to swap latitude and longitude on MySQL 8.1 or newer
  • Fix an error when overwriting an existing query bookmark
  • Fix some warnings that appear with PHP 8
  • Fix alter user privileges query when editing an account with MySQL 8.0.11 and newer
  • Fix issues regarding TIMESTAMP columns with default CURRENT_TIMESTAMP in MySQL 8.0.13 and newer
  • Fix a message that “Warning: error_reporting() has been disabled for security reasons” on php 7.x

Changes in phpMyAdmin 5.0.2 (2020-03-21):

  • PMASA-2020-2 SQL injection vulnerability in the user accounts page, particularly when changing a password
  • PMASA-2020-3 SQL injection vulnerability relating to the search feature
  • PMASA-2020-4 SQL injection and XSS having to do with displaying results
  • Removing of the “options” field for the external transformation.
  • Fix for copying a user account
  • Removed SET AUTOCOMMIT=0 from SQL export
  • Fix for the display of table borders
  • Fix for ENUM radio button user interface problems
  • Improved the prompt for abandoning changes when no changes were made in the SQL window
  • Fix for inserting a primary key with “insert as new row”
  • Fix incorrect suggested latest available version to version 5

Changes in phpMyAdmin 5.0.1 (2020-01-08):

  • Enable columns names by default for CSV exports
  • Add Metro theme
  • Automatically add the index when creating an auto increment column
  • Improvements to exporting views
  • Prompt the user for confirmation before running an UPDATE query with no WHERE clause
  • Improvements to how errors are show to the user (including allowing easier copying of the error text to the clipboard)
  • Added keystrokes to clear the line (ctrl+l) and clear the entire console window (ctrl+u)
  • Use charset ‘windows-1252’ when export format is MS Excel

Changes in phpMyAdmin 5.0.0 (2019-12-26):

  • Enable columns names by default for CSV exports
  • Add Metro theme
  • Automatically add the index when creating an auto increment column
  • Improvements to exporting views
  • Prompt the user for confirmation before running an UPDATE query with no WHERE clause
  • Improvements to how errors are show to the user (including allowing easier copying of the error text to the clipboard)
  • Added keystrokes to clear the line (ctrl+l) and clear the entire console window (ctrl+u)
  • Use charset ‘windows-1252’ when export format is MS Excel

Changes in phpMyAdmin 4.9.6 (2020-10-10):

  • PMASA-2020-5 XSS vulnerability with transformation feature
  • PMASA-2020-6 SQL injection vulnerability with the search feature

Changes in phpMyAdmin 4.9.4 (2020-01-08):

  • Fixed: Issue #15724 regarding two-factor authentication
    Fixed: PMASA-2020-1 which is an SQL injection vulnerability in the user accounts page

Changes in phpMyAdmin 4.9.3 (2019-12-26):

  • Several PHP notices and warnings including “Undefined index table_create_time,” a notice about error_reporting() being disabled for security reasons, and several Undefined Index errors.
  • Support CloudFront-Forwarded-Proto header for Amazon CloudFront proxy
  • Early compatibility with development versions of PHP 8
  • Fix replication actions (start, stop, etc)

Changes in phpMyAdmin 4.9.2 (2019-11-22):

  • Fixes for the “Failed to set session cookie” error which relates to the cookie name. In some cases, data stored in the cookie (such as the previously-used user account) may not be loaded from a previous phpMyAdmin cookie the first time you run version 4.9.2
  • Fix for Advisor with MySQL 8.0.3 and newer
  • Fix PHP deprecation errors
  • Fix a situation where exporting users after a delete query could remove users
  • Fix incorrect “You do not have privileges to manipulate with the users!” warning
  • Fix copying a database’s privileges and several other problems moving columns with MariaDB
  • Fix for phpMyAdmin not selecting all the values when using shift-click to select during Export

Changes in phpMyAdmin 4.9.1 (2019-09-21):

This release includes fixes for many bugs, including:

  • Editing columns with CURRENT_TIMESTAMP for MySQL versions 8.0.13 and newer
  • Compatibility issues with PHP 8
  • Export of GIS visualization
  • Enhanced descriptions for several collation types
  • Creating a user with a single quote in the password string
  • Unexpected quotes during import and export on text fields
  • Improvements to adding new tables to Designer
  • Fix an issue where an authenticated user could trigger heavy traffic between the database server and web server
  • Fix a weakness where an attacker, under certain conditions, working at the same time as an administrator is using the setup script, could delete a server from the setup script

Leave a Reply

0 Comments on phpMyAdmin 5.0.4 / 4.9.7 / 5.1.0 Snapshot 2020-11-08