HowTos Linux

Install latest phpMyAdmin on Linux

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add columns, execute any SQL statement, manage indexes on columns.

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…
READ  Install latest Dolphin Emulator for Gamecube & Wii on Linux

phpMyAdmin

Latest phpMyAdmin 4.6.5.2 changelog

  • Fixed SQL export with newlines

Previously fixed in 4.6.5.1:

  • an issue affecting a small number of users using $cfg[‘Servers’][$i][‘hide_db’] or $cfg[‘Servers’][$i][‘only_db’].
  • an issue affecting the create table dialog where the partition selection tool was overzealous and made it difficult to create a new table.

Highlights from the 4.6.5 release:

  • Fix for expanding in navigation pane
  • Reintroduced a simplified version of PmaAbsoluteUri directive (needed with reverse proxies)
  • Fix editing of ENUM/SET/DECIMAL field structures
  • Improvements to the parser

See Changelog for complete list

How to Install latest phpMyAdmin on Ubuntu 16.10 (Yakkety Yak), Ubuntu 16.04 (Xenial Xerus), Ubuntu 15.10 (Wily Werewolf), Ubuntu 15.04 (Vivid Vervet), Ubuntu 14.04 (Trusty Tahr), Ubuntu 12.04 (Precise)

sudo apt-get install mysql-server

sudo apt-add-repository ppa:nijel/phpmyadmin

sudo apt-get update

sudo apt-get upgrade

sudo apt-get install phpmyadmin

About the author

Admin

A passionate Linux and Open Source user. In my spare time, I love developing mobile games for fun (You can check my games out iOS Store | Google Play Store) and also spend time contributing to the Linux community.

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz