Home Linux phpMyAdmin: Managing databases like this for geeks

bannerebay

phpMyAdmin: Managing databases like this for geeks

by ace
phpMyAdmin: Managing databases like this for geeks

Obviously the title is a provocation, because with phpMyAdmin managing a database is extremely simple. It is the tool of choice for many and offers the best features in this segment.

Today we will teach you how to install phpMyAdmin on the new Ubuntu 20.04 LTS. Come on!

PhpMyAdmin is a free tool, written in PHP, that allows the administration of our databases through a simple browser in a very simple way.

Through a very intuitive and organized interface, phpMyAdmin allows any user to make a simplified management of MySQL and its databases.

Main features of phpMyAdmin

  • Support for most MySQL features
  • Search and delete databases, tables, views, fields and indexes
  • Create, copy, delete and rename databases, tables, fields and related information
  • Allows you to execute SQL-statements
  • User and privilege management
  • Management of procedures and triggers
  • Importing data from .CSV or SQL files
  • Export to various formats: CSV, SQL, XML, PDF, ISO / IEC 26300 – OpenDocument Text and Spreadsheet, Word, Excel, LATEX, among others
  • Administration of multiple servers

After teaching here how to install MySQL today we will teach you how to install phpMyAdmin.

How to install phpMyAdmin on Ubuntu 20.04 LTS

The installation of this tool is extremely simple. To do this, just open the terminal and execute the following command:

sudo apt install phpmyadmin

The tool occupies about 100 MB.

phpMyAdmin: Managing databases like this for geeks

During installation, the administrator will be asked what type of web server he uses.

phpMyAdmin: Managing databases like this for geeks

On the next screen, the user is asked if he wants to configure phpMyAdmin with dbconfig-common.

phpMyAdmin: Managing databases like this for geeks

Now enter a password to access this tool. Do not forget that it must be a strong password.

phpMyAdmin: Managing databases like this for geeks

And the configuration is done! To start using, just open the browser and access the graphical interface. Locally they can use the address http: // localhost / phpmyadmin.

phpMyAdmin: Managing databases like this for geeks

If you have never used this tool, give it a try! In upcoming tutorials we will leave some tips to get the best out of this tool that is free. In addition to Linux, this tool is also available for Windows.

banneraliexp

Related Articles

Leave a Comment

thirteen − twelve =

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More