PHPMyAdmin is open source free software, designed to handle the administration and management of MySQL databases through a graphic user interface. Written in PHP, PHPMyAdmin has become one of the most popular web-based MySQL management tools. PHPMyAdmin comes with detailed documentation and is being supported by a large multi-language community. PHPMyAdmin’s ever-growing list of features supports all commonly used operations such as browsing, dropping, creating, altering MySQL databases, tables, fields, and indexes. Also, PHPMyAdmin enables you to manage MySQL users and user privileges. Another commonly used PHPMyAdmin feature is its import function. With PHPMyAdmin, MySQL database import from backup is made easy and you can import an SQL or CSV dump with a few mouse clicks. Also, you can easily export your database in CSV, SQL, XML, Excel and other popular formats.

This chart bootstraps a phpMyAdmin deployment on a Kubernetes cluster using the Helm package manager.

Prerequisites

  • Kubernetes 1.8+ with Beta APIs enabled

About

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) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

phpMyAdmin bookphpMyAdmin Starter

phpMyAdmin comes with a wide range of documentation and users are welcome to update our 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 the developers – Mastering phpMyAdmin for Effective MySQL Management, which is available in English and Spanish.

To ease usage to a wide range of people, phpMyAdmin is being translated into 72 languages and supports both LTR and RTL languages.

phpMyAdmin is a mature project with a stable and flexible code base; you can find out more about the project and its history and the awards it earned. When the project turned 15, we published a celebration page.

The phpMyAdmin project is a member of Software Freedom Conservancy. SFC is a not-for-profit organization that helps promote, improve, develop, and defends Free, Libre, and Open Source Software (FLOSS) projects.

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…

How to install PHPMyAdmin on a Linux host

The combination between the Linux operation system, the Apache web server, the MySQL database server, and the PHP scripting language has become one of the most popular web hosting platforms. Stacked together, these free, open source software projects are the essentials of the LAMP server software bundle. If you are running a Linux host and you already have LAMP installed and configured on your machine, you probably need to install PHPMyAdmin in order to have a convenient and easy-to-use tool for managing your MySQL databases.

For example, we will show you how to install PHPMyAdmin on an Ubuntu Server host. First, open a terminal window and use the APT package manager to install PHPMyAdmin.

How to create a database table using PHPMyAdmin

With PHPMyAdmin, the process of MySQL table creation is now easier than ever. Since the PHPMyAdmin tool is integrated into our web hosting Control Panel, our clients need simply to log into their Control Panel, go to the MySQL Databases section and then select the database that they wish to create a table for. This will automatically open the PHPMyAdmin tool.

Once within PHPMyAdmin, you need to click on the ‘Structure’ tab. At the bottom of the page, just below the tables list, you can enter the ‘Create new table on database’ wizard. Enter the MySQL table name and the number of fields for this particular table and then press the ‘Go’ button. This will take you to a step-by-step setup wizard. First, you should name all fields, then select the appropriate type for every field using the ‘Type’ drop-down menu, and enter a value for the length of each field. Then you should assign ‘Attributes’ to each field, select a null option from the ‘Null’ drop-down list and define whether the field is a primary key or not. The last actions required from you will be to select the table type and collation method and then hit the ‘Save’ button to complete your table creation.

How to manage a database using PHPMyAdmin

The PHPMyAdmin tool provides the most complete list of MySQL management operations. Using its graphical interface you can easily perform the basic Alter table functions. The database’s ‘Operations’ tab enables you to create new tables, to rename or copy your database, or to change its collation. When you browse a table the ‘Operations’ tab gives you access to all the basic Alter table functions. You are allowed to change or delete the existing values for any of the table creation entries, such as the field’s name and attributes, its type and the length of the allowed characters and its collation method. Also, you can alter the MySQL table order, and rename, move or copy the table.

Tell us about a new Kubernetes application

Newsletter

Never miss a thing! Sign up for our newsletter to stay updated.

About

Discover and learn about everything Kubernetes

Navigation