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

phpMyAdmin 4.2.0 Released: Installation and Upgrade

phpMyAdmin is an awesome web-based database management tool. Learning phpMyAdmin can come in very handy for bloggers and web-developers. This post introduces the recently released phpMyAdmin 4.2.0 update.

phpMyAdmin 4.2.0

What’s New in phpMyAdmin 4.2.0

phpMyAdmin 4.2.0 comes with a lot of fixes and improvements:

+ rfe #1403 Export only triggers
+ rfe #1483 Export Server/Database/Table without triggers
+ rfe #1662 Add table comment tool tip in database structure page
+ rfe #1447 Single table for display Character Sets and Collations
+ rfe #1455 Display icons/text/both for the table row actions
+ rfe #1473 Transformation to convert Boolean value to text
– bug #4157 Changing users password will delete it
+ rfe #1474 Text transformation combines Append and Prepend
+ Added warning about the mysql extension being deprecated and removed the extension directive
+ Added support for scatter charts
+ rfe #1478 Make Column Headings Sticky
+ rfe #1480 Enhance privileges initials table
+ rfe #1472 [interface] Break “Edit privileges” with sub-menus
+ rfe #1466 Minor refactoring required
+ rfe #1004 Create indexes at the end in SQL export
+ rfe #1479 Relations edit form for larger monitors
+ rfe #1475 Inline query box vertical resize
+ rfe #1500 [interface] Add bottom border to top menu container
+ rfe #1498 Add datepicker for ‘TIME’ type
– bug #4237 HTTP Referer disclosure in SQL links
+ rfe Show full names on navigation hover
+ rfe #1505 Behaviour on click on a routine in nav panel
+ rfe #1418 Support more than one separating character on CSV import
+ rfe #569 Load/Save Query By Example
– bug #4281 Grid edit ENUM field, dialog disappears when trying to select
– bug #4304 DB export using zip compression generates an empty archive
+ rfe #1508 confirmation message at the top
– bug #4306 breadcrubs wrong on table create
+ rfe #1511 better validate database name for copying
+ rfe #1510 Database tab “Drop” button should be a link
+ rfe #1513 Highlight required form fields after failed submission
+ rfe #1460 Redirect to login page after session has expired
– bug #4316 Grid edit: can’t change month on date fields
+ rfe #1501 add maxlength by field with length-spec
+ rfe #1512 Import happily doesn’t do anything with no file name provided
+ rfe #1514 Add function to all the insert boxes automatically
+ rfe #1515 Option to skip tables larger than n
+ rfe #1486 Possibility of disabling database expansion
+ rfe #1476 Favourite tables select box
+ rfe #420 $cfg[‘CharEditing’]=’textarea’ for structure edit
+ rfe #1329 Avoid editing of fields which are part of relation
+ rfe [interface] Highlight active left menu item in setup
+ rfe Filter on-screen rows during Browse
– Removed support for SQL Validator (SOAP service no longer offered)
– bug #4352 Settings > Manage: incorrect messages
– bug #4337 “More” in Actions area doesn’t collapse to fit available space
– bug #4375 Group two DB, one’s name is the prefix of the other one
– bug #4070 Confusing database/table grouping
– bug #4366 Creating Index doesn’t update index-list

The complete changelog for phpMyAdmin 4.2.0 can be found here.

Installation and Configuration Instructions

Ubuntu Installation
phpMyAdmin Tweaks

Recommended Reading:

Upgrade Instructions

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

sudo apt-get update
sudo apt-get upgrade

That’s it. Enjoy administering your databases using phpMyAdmin’s web interface.

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.
Tags

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

Anand

Anand is a self-learned computer enthusiast, a part-time blogger, and a Food Scientist by career. He has been blogging since 2010 on Linux, Ubuntu, Home/Media/File Servers, Smart Home Automation, and related HOW-TOs on htpcbeginner.com and smarthomebeginner.com.

Archives

Join the other 110,000 followers