Why do users prefer PHPMyAdmin to be installed on Ubuntu?

Because PHPMyAdmin allows users to interact with MySQL through a web interface

That’s why we often get requests from customers to install PHPMyAdmin as part of our Technical Support Services.

Today, we’ll see how to install PHPMyAdmin on Ubuntu.

Importance of PHPMyAdmin?

Often, the server administration task includes Database management. However, users may not feel comfortable interacting with the system solely from the MySQL prompt. Here’s the importance of phpMyAdmin that creates so that users can interact with MySQL through a web interface.

Typical operations like management of databases, tables, indexes, permissions, and so on are executed with the user interface.

Some of the features include the following,

1. MySQL database management.
2. Web interface.
3. Execute custom SQL queries
4. Multiple-server administration
5. Can import and export data in different formats, including SQL, XML and CSV
6. Ability to back up the MySQL databases in manual mode

How to install PHPMyAdmin on Ubuntu

In this article, let’s see how our Support Engineers install and secure phpMyAdmin so that users can safely use it to manage the databases on an Ubuntu 18.04 system.

As prerequisites, it is necessary to have root access to the server and firewall configured with ufw. LAMP should be installed on Ubuntu 18.04 server.

Importantly, we can install phpMyAdmin from the default Ubuntu repositories.

1. Initially, we update the server’s package index.

apt update && upgrade

2. Next, we install PhpMyAdmin and PHP extensions for managing non-ASCII string and necessary tools, execute the command given below:

apt install phpmyadmin php-mbstring php-gettext

3. While executing the commands, it asks for the webserver selection, we select Apache2 and select ENTER.

4. Also, in the next step, we have the option for automatic setup or to create the database manually. We select the automatic installation by pressing ENTER for yes.

5. In the next step, we set up the PhpMyAdmin password.

6. Again we enable PHP extension.

phpenmod mbstring

7. Afterwards, we restart Apache for the changes to be recognized:

systemctl restart apache2

We ensure the PhpMyAdmin installation by going to http://ip/phpmyadmin

[Need any further assistance to install PhpMyAdmin? – We’re available 24*7]

Conclusion

In short, PHPMyAdmin allows users to interact with MySQL through a web interface and makes MySQL database management easier. Today, we saw how our Support Engineers install PhpMyAdmin on Ubuntu