Home » News Updates » phpMyAdmin 4.5.1 Released: Installation and Upgrade

phpMyAdmin 4.5.1 Released: Installation and Upgrade

On October 23, 2015 phpMyAdmin introduced the phpMyAdmin 4.5.1 release.

phpMyAdmin is a free, open source tool developed in PHP and intended to handle the administration of MySQL database management system (DBMS).

phpMyAdmin is designed to perform a wide range of operations on MySQL over the web. It offers the user friendly web interface, support for most MySQL features, management of MySQL users and privileges, management of stored procedures and triggers, import and export of data from various sources, administration of multiple servers and much more.

phpMyAdmin 4.5.1
phpMyAdmin 4.5.1

What’s New in phpMyAdmin 4.5.1 Release

Since our last publication, covering the 4.4.12 release, phpMyAdmin introduced major, minor versions and hot fixes – 4.4.15, 4.5.0, 4.5.0.1, 4.5.0.2, 4.5.1.

The major 4.5.0.0 version came with followig improvements:

  • Improvements to the Console feature
  • Include structure in PDF export
  • Validate data before import
  • Support CHECKSUM TABLE operation
  • Improved operations regarding partitions
  • Alter privileges when renaming or copying a database or table
  • Several improvements related to speed and responsiveness
  • Improved print view
  • Use CTRL or ALT plus arrow keys to navigate in grid editor
  • Use plain-English destinations for $cfg[‘NavigationTreeDefaultTabTable’], $cfg[‘DefaultTabServer’],
  • $cfg[‘DefaultTabDatabase’], and $cfg[‘DefaultTabTable’]. The old style values will still work, but
  • this makes it easier for new users to easily understand the destination links.
  • Integrate SQL debugging into Console
  • Restore row editing when no unique/primary key exists
  • Allow exporting one file per table and one file per database
  • Improvements to using multiple servers with the auth_type cookie
  • Support virtual columns (MySQL 5.7.5+)
  • Add or improve support for several MariaDB features including process list and virtual/persistent columns
  • Improved handling of cached data when upgrading phpMyAdmin
  • Add SHA256 security password support

phpMyAdmin 4.5.0.1 and 4.5.0.1 comes with followig hot fixes:

  • issue #11497 Incorrect indexes when exporting
  • issue #11492 AUTO_INCREMENT statements are partly missing from exports

phpMyAdmin 4.5.1 comes with followig fixes:

  • issue Invalid argument supplied for foreach()
  • issue array_key_exists() expects parameter 2 to be array
  • issue #11480 Notice Undefined index: drop_database
  • issue #11486 Server variable edition in ANSI_QUOTES sql_mode: losing current value
  • issue #11491 Propose table structure broken
  • issue #11464 phpMyAdmin suggests upgrading to newer version not usable on that system
  • issue #11495 ‘PMA_Microhistory’ is undefined
  • issue #11496 Incorrect definition for getTablesWhenOpen()
  • issue #11500 Error when creating new user on MariaDB 10.0.21
  • issue #11505 Notice on htmlspecialchars()
  • issue Notice in Structure page of views
  • issue #11510 AUTO_INCREMENT always exported when IF NOT EXISTS is on
  • issue #11516 Some partitions are missing in copied table
  • issue #11521 Notice of undefined variable when performing SHOW CREATE
  • issue #11509 Error exporting sql query results with table alias
  • issue #11512 SQL editing window does not recognise ‘OUTER’ keyword in ‘LEFT OUTER JOIN’
  • issue #11518 “NOT IN” clause not recognized (MySQL 5.6 and 5.7)
  • issue #11524 Yellow star does not change in database Structure after add/remove from favorites
  • issue #11531 Invalid SQL in table definition when exporting table
  • issue #11526 Foreign key to other database’s tables fails
  • issue #11519 Bug while exporting results when a joined table field name is in SELECT query
  • issue #11522 Strange behavior on table rename
  • issue #11539 Rename table does not result in refresh in left panel
  • issue #11541 Missing arguments for PMA_Table::generateAlter()
  • issue #11544 Notices about undefined indexes on structure pages of information_schema tables
  • issue Change minimum PHP version for Composer
  • issue #11542 Import parser and backslash
  • issue #11546 “Visualize GIS data” seems to be broken
  • issue #11548 Confirm box on “Reset slave” option
  • issue Fix cookies clearing on version change
  • issue #11558 Cannot execute SQL with subquery
  • issue #11520 Incorrect syntax creating a user using mysql_native_password with MariaDB
  • issue #11561 Cannot use third party auth plugins

The complete changelog for the phpMyAdmin 4.5.1 and other releases can be found here.

Installation and Configuration Instructions

Ubuntu Installation
phpMyAdmin Tweaks
“Additional features have been deactivated” Error

Recommended Reading:

Upgrade Instructions

If you followed our installation guide for Ubuntu, then you can upgrade to phpMyAdmin 4.4.12 using the following commands:

sudo apt-get update
sudo apt-get upgrade

Complete instructions can be found in the phpMyAdmin 4.5.1 Documentation.

Please contact phpMyAdmin Support to address any installation or upgrade issues to the phpMyAdmin 4.5.1 version.

We Are Hiring: Familiar with Media Streaming, HTPC, Home Server, Smart Home, and Home Automation topics? Write about it and earn money. No writing experience needed. APPLY HERE.

Get 20% OFF with IPVanish VPN:

♦   Hide your browsing and streaming activity: No logs and no tracking
♦   Access geo-restricted content from anywhere
♦   Encrypt and anonymize: Kodi, Plex, Downloads, Personal Info
♦   Windows, Mac, Linux, Android, iOS, Router, and more.
♦   Money back guarantee - Sign Up Now

About the author

Daisy

Daisy is a starting part-time blogger with brief experience in software engineering and interests in many other areas.

Archives

Join the other 110,000 followers

Don’t Miss Out!