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.0 Snapshot 2019-03-26/ 4.8.5.0

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.50 out of 5)
phpMyAdmin 5.0.0 Snapshot 2019-03-26/ 4.8.5.0

phpMyAdmin 4.8 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 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 18 year old 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 4.8.5 (2019-01-26):

The security fixes involve:

  • Arbitrary file read vulnerability (https://www.phpmyadmin.net/security/PMASA-2019-1)
  • SQL injection in the Designer interface (https://www.phpmyadmin.net/security/PMASA-2019-2)

The arbitrary file read vulnerability could also be exploited to delete arbitrary files on the server. This attack requires that phpMyAdmin be run with the $cfg['AllowArbitraryServer'] directive set to true, which is not the default. An attacker must run a malicious server process that will masquerade as a MySQL server. This exploit has been found and fixed recently in several other related projects and appears to be caused by a bug in PHP (https://bugs.php.net/bug.php?id=77496).

In addition to the security fixes, this release also includes these bug fixes and more as part of our regular release cycle:

  • Export to SQL format not available
  • QR code not shown when adding two-factor authentication to a user account
  • Issue with adding a new user in MySQL 8.0.11 and newer
  • Frozen interface relating to Text_Plain_Sql plugin
  • Table level Operations tab was missing

Leave a Reply

0 Comments on phpMyAdmin 5.0.0 Snapshot 2019-03-26/ 4.8.5.0