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.
During installation, the administrator will be asked what type of web server he uses.
On the next screen, the user is asked if he wants to configure phpMyAdmin with dbconfig-common.
Now enter a password to access this tool. Do not forget that it must be a strong password.
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.
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.